Impresszum

 

A MAP adatbázis fejlesztője és működtetője a Magyar Madártani és Természetvédelmi Egyesület (MME) Monitoring Központja.

Kérjük, hogy az adatbázissal kapcsolatban felmerülő problémákkal és kérdésekkel forduljanak munkatársainkhoz, a map@mme.hu e-mail címen!

Az MME Monitoring Központ információs honlapját itt érheti el: Madárszámlálók >>

 


 

Az adatbázis adminisztrátorai:

Nagy Károly (monitoring és kutatási csoportvezető)

Görögh Zoltán (monitoring koordinátor)

Kecskés Zsolt (adatbázis- és web-programozó)

 

Tervező és programozó:

Nagy Károly, Kecskés Zsolt, Görögh Zoltán, Nagy Zsolt és Dr. Szép Tibor

 


 

MME Monitoring Központ

Nyíregyháza Sóstói u. 31/B., Nyíregyházi Főiskola B épület / 312

Postacím: 4401 Nyíregyháza 1. Pf. 286.

Telefon: +36 42 599400 - mellék száma: 2295

Mobil: +36 30 9066285

E-mail: monitoring@mme.hu

(default) 21 queries took 6705 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public';1691699
2SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'pages' AND table_schema = 'public' ORDER BY position9916
3SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'admins' AND table_schema = 'public' ORDER BY position4410
4SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'coordinators' AND table_schema = 'public' ORDER BY position9911
5SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'observationbases' AND table_schema = 'public' ORDER BY position212114
6SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'ksh_telepulesek' AND table_schema = 'public' ORDER BY position6611
7SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'obobservers' AND table_schema = 'public' ORDER BY position449
8SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'observers' AND table_schema = 'public' ORDER BY position557
9SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'obsareas' AND table_schema = 'public' ORDER BY position337
10SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'observationbaseutm25x25s' AND table_schema = 'public' ORDER BY position447
11SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'observationbasevideos' AND table_schema = 'public' ORDER BY position557
12SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'observationbasevoices' AND table_schema = 'public' ORDER BY position557
13SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'observationbaseimages' AND table_schema = 'public' ORDER BY position11118
14SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'observationbasevvmcs' AND table_schema = 'public' ORDER BY position667
15SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'specsummaries' AND table_schema = 'public' ORDER BY position18189
16SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'specdetails' AND table_schema = 'public' ORDER BY position323211
17SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'tokens' AND table_schema = 'public' ORDER BY position558
18SELECT COUNT(*) AS "count" FROM "observationbases" AS "observationbase" LEFT JOIN "ksh_telepulesek" AS "kshtelepules" ON ("observationbase"."kshkod" = "kshtelepules"."kshkod") WHERE "upload_type" = '1' 11299
19SELECT COUNT(*) AS "count" FROM "specsummaries" AS "specsummary" WHERE 1 = 1 113225
20SELECT COUNT(DISTINCT utm) as count FROM "observationbases" AS "observationbase" LEFT JOIN "ksh_telepulesek" AS "kshtelepules" ON ("observationbase"."kshkod" = "kshtelepules"."kshkod") WHERE 1 = 1 113022
21SELECT "page"."id" AS "page__id", "page"."controller" AS "page__controller", "page"."action" AS "page__action", "page"."megjegyzes" AS "page__megjegyzes", "page"."pagetext_hun" AS "page__pagetext_hun", "page"."pagetext_eng" AS "page__pagetext_eng", "page"."pagetext_rou" AS "page__pagetext_rou", "page"."align" AS "page__align", "page"."app_id" AS "page__app_id" FROM "pages" AS "page" WHERE "controller" = 'oldalak' AND "action" = 'imprint' AND "app_id" = '2' 111
(auth) 2 queries took 28 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public';1691698
2SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'users' AND table_schema = 'public' ORDER BY position414120