explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 55yp

Settings
# exclusive inclusive rows x rows loops node
1. 0.528 54,391.662 ↓ 61.7 185 1

Sort (cost=55,259.48..55,259.49 rows=3 width=216) (actual time=54,391.652..54,391.662 rows=185 loops=1)

  • Sort Key: tbw.fallid, tbw.startdate, tbw.missingdate
  • Sort Method: quicksort Memory: 74kB
2.          

CTE bewegdata

3. 0.448 54,385.609 ↑ 1.0 444 1

Subquery Scan on abc (cost=7,605.79..55,185.43 rows=461 width=39) (actual time=30.097..54,385.609 rows=444 loops=1)

4. 8.329 54,385.161 ↑ 1.0 444 1

Nested Loop (cost=7,605.79..55,178.52 rows=461 width=79) (actual time=30.092..54,385.161 rows=444 loops=1)

  • Join Filter: ((((rownum - 1)))::numeric <= (SubPlan 1))
  • Rows Removed by Join Filter: 2,468
5. 0.640 1.944 ↓ 8.0 8 1

Result (cost=271.34..272.21 rows=1 width=103) (actual time=1.438..1.944 rows=8 loops=1)

6. 0.013 1.304 ↓ 8.0 8 1

Sort (cost=271.34..271.35 rows=1 width=95) (actual time=1.300..1.304 rows=8 loops=1)

  • Sort Key: tb.fallid
  • Sort Method: quicksort Memory: 26kB
7. 0.037 1.291 ↓ 8.0 8 1

Nested Loop Semi Join (cost=258.06..271.33 rows=1 width=95) (actual time=1.192..1.291 rows=8 loops=1)

8. 0.014 1.230 ↓ 8.0 8 1

Nested Loop (cost=257.78..263.02 rows=1 width=55) (actual time=1.170..1.230 rows=8 loops=1)

9. 0.085 1.200 ↓ 8.0 8 1

Bitmap Heap Scan on tblbewegung tb (cost=257.78..261.92 rows=1 width=47) (actual time=1.162..1.200 rows=8 loops=1)

  • Recheck Cond: ((((((pflegerischeoe)::text = 'PSA'::text) AND (endedatum >= to_date('2020-06-25'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying)) AND (endedatum <= add_months(to_date('2020-06-25'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying), '6'::numeric))) OR (((pflegerischeoe)::text = 'PSA'::text) AND (endedatum = to_date('31.12.9990'::character varying, 'DD.MM.YYYY'::character varying)))) AND (bewegungsdatum >= add_months(to_date('2020-06-01'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying), '-6'::numeric)) AND (bewegungsdatum <= to_date('2020-06-01'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying))) OR ((bewegungsdatum >= to_date('2020-06-01'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying)) AND (bewegungsdatum <= to_date('2020-06-25'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying)) AND ((((pflegerischeoe)::text = 'PSA'::text) AND (endedatum >= to_date('2020-06-25'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying)) AND (endedatum <= add_months(to_date('2020-06-25'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying), '6'::numeric))) OR (((pflegerischeoe)::text = 'PSA'::text) AND (endedatum = to_date('31.12.9990'::character varying, 'DD.MM.YYYY'::character varying))))) OR ((bewegungsdatum >= to_date('2020-06-01'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying)) AND (bewegungsdatum <= to_date('2020-06-25'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying)) AND ((((pflegerischeoe)::text = 'PSA'::text) AND (endedatum >= to_date('2020-06-01'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying)) AND (endedatum <= to_date('2020-06-25'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying))) OR (((pflegerischeoe)::text = 'PSA'::text) AND (endedatum = to_date('31.12.9990'::character varying, 'DD.MM.YYYY'::character varying))))) OR (((((pflegerischeoe)::text = 'PSA'::text) AND (endedatum >= to_date('2020-06-01'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying)) AND (endedatum <= to_date('2020-06-25'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying))) OR (((pflegerischeoe)::text = 'PSA'::text) AND (endedatum = to_date('31.12.9990'::character varying, 'DD.MM.YYYY'::character varying)))) AND (bewegungsdatum >= add_months(to_date('2020-06-01'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying), '-6'::numeric)) AND (bewegungsdatum <= to_date('2020-06-01'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying))))
  • Filter: ((stornierer IS NULL) AND ((bewegungstyp)::text = ANY ('{Aufnahme,Verlegung}'::text[])) AND ((status IS NULL) OR ((status)::text <> 'P'::text)) AND (NOT (hashed SubPlan 4)) AND ((einrichtung)::text = 'Ein1'::text) AND ((fachlicheoe)::text = 'ADMIN'::text) AND (((bewegungsdatum >= add_months(to_date('2020-06-01'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying), '-6'::numeric)) AND (bewegungsdatum <= to_date('2020-06-01'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying)) AND (((endedatum >= to_date('2020-06-25'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying)) AND (endedatum <= add_months(to_date('2020-06-25'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying), '6'::numeric))) OR (endedatum = to_date('31.12.9990'::character varying, 'DD.MM.YYYY'::character varying)))) OR ((bewegungsdatum >= to_date('2020-06-01'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying)) AND (bewegungsdatum <= to_date('2020-06-25'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying)) AND (((endedatum >= to_date('2020-06-25'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying)) AND (endedatum <= add_months(to_date('2020-06-25'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying), '6'::numeric))) OR (endedatum = to_date('31.12.9990'::character varying, 'DD.MM.YYYY'::character varying)))) OR ((bewegungsdatum >= to_date('2020-06-01'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying)) AND (bewegungsdatum <= to_date('2020-06-25'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying)) AND (((endedatum >= to_date('2020-06-01'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying)) AND (endedatum <= to_date('2020-06-25'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying))) OR (endedatum = to_date('31.12.9990'::character varying, 'DD.MM.YYYY'::character varying)))) OR ((bewegungsdatum >= add_months(to_date('2020-06-01'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying), '-6'::numeric)) AND (bewegungsdatum <= to_date('2020-06-01'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying)) AND (((endedatum >= to_date('2020-06-01'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying)) AND (endedatum <= to_date('2020-06-25'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying))) OR (endedatum = to_date('31.12.9990'::character varying, 'DD.MM.YYYY'::character varying))))))
  • Rows Removed by Filter: 5
  • Heap Blocks: exact=10
10. 0.002 0.915 ↓ 0.0 0 1

BitmapOr (cost=222.86..222.86 rows=1 width=0) (actual time=0.915..0.915 rows=0 loops=1)

11. 0.009 0.392 ↓ 0.0 0 1

BitmapAnd (cost=71.60..71.60 rows=1 width=0) (actual time=0.392..0.392 rows=0 loops=1)

12. 0.000 0.102 ↓ 0.0 0 1

BitmapOr (cost=33.72..33.72 rows=83 width=0) (actual time=0.102..0.102 rows=0 loops=1)

13. 0.062 0.062 ↓ 0.0 0 1

Bitmap Index Scan on xie7tblbewegung (cost=0.00..17.36 rows=1 width=0) (actual time=0.062..0.062 rows=0 loops=1)

  • Index Cond: (((pflegerischeoe)::text = 'PSA'::text) AND (endedatum >= to_date('2020-06-25'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying)) AND (endedatum <= add_months(to_date('2020-06-25'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying), '6'::numeric)))
14. 0.040 0.040 ↓ 3.5 289 1

Bitmap Index Scan on xie7tblbewegung (cost=0.00..16.36 rows=83 width=0) (actual time=0.040..0.040 rows=289 loops=1)

  • Index Cond: (((pflegerischeoe)::text = 'PSA'::text) AND (endedatum = to_date('31.12.9990'::character varying, 'DD.MM.YYYY'::character varying)))
15. 0.281 0.281 ↓ 3.8 5,024 1

Bitmap Index Scan on xie2tblbewegung (cost=0.00..37.63 rows=1,320 width=0) (actual time=0.281..0.281 rows=5,024 loops=1)

  • Index Cond: ((bewegungsdatum >= add_months(to_date('2020-06-01'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying), '-6'::numeric)) AND (bewegungsdatum <= to_date('2020-06-01'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying)))
16. 0.011 0.111 ↓ 0.0 0 1

BitmapAnd (cost=39.46..39.46 rows=1 width=0) (actual time=0.111..0.111 rows=0 loops=1)

17. 0.035 0.035 ↓ 5.1 542 1

Bitmap Index Scan on xie2tblbewegung (cost=0.00..5.49 rows=106 width=0) (actual time=0.035..0.035 rows=542 loops=1)

  • Index Cond: ((bewegungsdatum >= to_date('2020-06-01'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying)) AND (bewegungsdatum <= to_date('2020-06-25'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying)))
18. 0.000 0.065 ↓ 0.0 0 1

BitmapOr (cost=33.72..33.72 rows=83 width=0) (actual time=0.065..0.065 rows=0 loops=1)

19. 0.031 0.031 ↓ 0.0 0 1

Bitmap Index Scan on xie7tblbewegung (cost=0.00..17.36 rows=1 width=0) (actual time=0.031..0.031 rows=0 loops=1)

  • Index Cond: (((pflegerischeoe)::text = 'PSA'::text) AND (endedatum >= to_date('2020-06-25'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying)) AND (endedatum <= add_months(to_date('2020-06-25'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying), '6'::numeric)))
20. 0.034 0.034 ↓ 3.5 289 1

Bitmap Index Scan on xie7tblbewegung (cost=0.00..16.36 rows=83 width=0) (actual time=0.034..0.034 rows=289 loops=1)

  • Index Cond: (((pflegerischeoe)::text = 'PSA'::text) AND (endedatum = to_date('31.12.9990'::character varying, 'DD.MM.YYYY'::character varying)))
21. 0.008 0.101 ↓ 0.0 0 1

BitmapAnd (cost=39.46..39.46 rows=1 width=0) (actual time=0.101..0.101 rows=0 loops=1)

22. 0.027 0.027 ↓ 5.1 542 1

Bitmap Index Scan on xie2tblbewegung (cost=0.00..5.49 rows=106 width=0) (actual time=0.027..0.027 rows=542 loops=1)

  • Index Cond: ((bewegungsdatum >= to_date('2020-06-01'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying)) AND (bewegungsdatum <= to_date('2020-06-25'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying)))
23. 0.000 0.066 ↓ 0.0 0 1

BitmapOr (cost=33.72..33.72 rows=83 width=0) (actual time=0.066..0.066 rows=0 loops=1)

24. 0.030 0.030 ↓ 0.0 0 1

Bitmap Index Scan on xie7tblbewegung (cost=0.00..17.35 rows=1 width=0) (actual time=0.030..0.030 rows=0 loops=1)

  • Index Cond: (((pflegerischeoe)::text = 'PSA'::text) AND (endedatum >= to_date('2020-06-01'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying)) AND (endedatum <= to_date('2020-06-25'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying)))
25. 0.036 0.036 ↓ 3.5 289 1

Bitmap Index Scan on xie7tblbewegung (cost=0.00..16.36 rows=83 width=0) (actual time=0.036..0.036 rows=289 loops=1)

  • Index Cond: (((pflegerischeoe)::text = 'PSA'::text) AND (endedatum = to_date('31.12.9990'::character varying, 'DD.MM.YYYY'::character varying)))
26. 0.008 0.309 ↓ 0.0 0 1

BitmapAnd (cost=71.60..71.60 rows=1 width=0) (actual time=0.309..0.309 rows=0 loops=1)

27. 0.000 0.064 ↓ 0.0 0 1

BitmapOr (cost=33.72..33.72 rows=83 width=0) (actual time=0.064..0.064 rows=0 loops=1)

28. 0.029 0.029 ↓ 0.0 0 1

Bitmap Index Scan on xie7tblbewegung (cost=0.00..17.35 rows=1 width=0) (actual time=0.029..0.029 rows=0 loops=1)

  • Index Cond: (((pflegerischeoe)::text = 'PSA'::text) AND (endedatum >= to_date('2020-06-01'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying)) AND (endedatum <= to_date('2020-06-25'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying)))
29. 0.035 0.035 ↓ 3.5 289 1

Bitmap Index Scan on xie7tblbewegung (cost=0.00..16.36 rows=83 width=0) (actual time=0.035..0.035 rows=289 loops=1)

  • Index Cond: (((pflegerischeoe)::text = 'PSA'::text) AND (endedatum = to_date('31.12.9990'::character varying, 'DD.MM.YYYY'::character varying)))
30. 0.237 0.237 ↓ 3.8 5,024 1

Bitmap Index Scan on xie2tblbewegung (cost=0.00..37.63 rows=1,320 width=0) (actual time=0.237..0.237 rows=5,024 loops=1)

  • Index Cond: ((bewegungsdatum >= add_months(to_date('2020-06-01'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying), '-6'::numeric)) AND (bewegungsdatum <= to_date('2020-06-01'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying)))
31.          

SubPlan (for Bitmap Heap Scan)

32. 0.200 0.200 ↑ 1.0 13 1

Seq Scan on katbewegungsart (cost=0.00..34.89 rows=13 width=8) (actual time=0.021..0.200 rows=13 loops=1)

  • Filter: ((hostcode)::text = ANY ('{B,MB}'::text[]))
  • Rows Removed by Filter: 1,098
33. 0.016 0.016 ↑ 1.0 1 8

Seq Scan on katpprparameter (cost=0.00..1.09 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=8)

  • Filter: ((einrichtung)::text = 'Ein1'::text)
  • Rows Removed by Filter: 6
34. 0.024 0.024 ↑ 1.0 1 8

Index Scan using xpkkatoe on katoe (cost=0.27..8.30 rows=1 width=7) (actual time=0.003..0.003 rows=1 loops=8)

  • Index Cond: ((oe)::text = 'PSA'::text)
  • Filter: ((nvl(oenichtppr, 'N'::character varying))::text <> 'J'::text)
35. 394.320 54,360.328 ↑ 3.8 364 8

Result (cost=7,334.45..53,327.47 rows=1,384 width=8) (actual time=3.702..6,795.041 rows=364 loops=8)

  • Filter: ((rownum)::numeric < GREATEST('365'::numeric, (fgetdatedifference(to_date('2020-06-25'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying), to_date('2020-06-01'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying)) + '1'::numeric)))
36. 3.896 53,966.008 ↓ 2.0 2,826 8

Append (cost=7,334.45..53,310.17 rows=1,384 width=0) (actual time=3.681..6,745.751 rows=2,826 loops=8)

37. 4,452.832 5,529.744 ↓ 3.5 364 8

Subquery Scan on *SELECT* 1 (cost=7,334.45..9,531.75 rows=103 width=0) (actual time=3.681..691.218 rows=364 loops=8)

  • Filter: ((rownum)::numeric < GREATEST('365'::numeric, (fgetdatedifference(to_date('2020-06-25'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying), to_date('2020-06-01'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying)) + '1'::numeric)))
  • Rows Removed by Filter: 32,355
38. 244.984 1,076.912 ↓ 105.5 32,719 8

Nested Loop (cost=7,334.45..9,446.50 rows=310 width=192) (actual time=3.642..134.614 rows=32,719 loops=8)

39. 55.101 308.424 ↓ 59.5 32,719 8

Hash Join (cost=7,334.03..8,855.97 rows=550 width=4) (actual time=3.630..38.553 rows=32,719 loops=8)

  • Hash Cond: (c.relnamespace = n.oid)
40. 178.585 252.880 ↓ 19.8 32,853 8

Hash Join (cost=7,275.16..8,792.73 rows=1,656 width=8) (actual time=3.513..31.610 rows=32,853 loops=8)

  • Hash Cond: (x.indrelid = c.oid)
41. 46.384 46.384 ↑ 1.0 41,223 8

Seq Scan on pg_index x (cost=0.00..1,409.32 rows=41,232 width=8) (actual time=0.003..5.798 rows=41,223 loops=8)

42. 1.283 27.911 ↓ 3.0 8,735 1

Hash (cost=7,238.53..7,238.53 rows=2,930 width=8) (actual time=27.910..27.911 rows=8,735 loops=1)

  • Buckets: 16,384 (originally 4096) Batches: 1 (originally 1) Memory Usage: 470kB
43. 26.628 26.628 ↓ 3.0 8,735 1

Seq Scan on pg_class c (cost=0.00..7,238.53 rows=2,930 width=8) (actual time=0.012..26.628 rows=8,735 loops=1)

  • Filter: ((relkind = ANY ('{r,p}'::char[])) AND has_table_privilege(oid, 'SELECT, INSERT, UPDATE, DELETE, TRUNCATE, REFERENCES, TRIGGER'::text))
  • Rows Removed by Filter: 64,246
44. 0.013 0.443 ↑ 4.1 71 1

Hash (cost=55.23..55.23 rows=291 width=4) (actual time=0.442..0.443 rows=71 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
45. 0.430 0.430 ↑ 4.1 71 1

Seq Scan on pg_namespace n (cost=0.00..55.23 rows=291 width=4) (actual time=0.016..0.430 rows=71 loops=1)

  • Filter: (has_schema_privilege(oid, 'USAGE'::text) AND (nspname <> ALL ('{pg_catalog,information_schema,pg_toast}'::name[])))
  • Rows Removed by Filter: 805
46. 523.504 523.504 ↑ 1.0 1 261,752

Index Scan using pg_class_oid_index on pg_class i (cost=0.42..1.07 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=261,752)

  • Index Cond: (oid = x.indexrelid)
  • Filter: (relkind = ANY ('{i,I}'::char[]))
47. 2,589.896 44,490.864 ↑ 1.7 364 8

Subquery Scan on all_sequences (cost=58.87..11,157.42 rows=603 width=0) (actual time=0.889..5,561.358 rows=364 loops=8)

  • Filter: ((rownum)::numeric < GREATEST('365'::numeric, (fgetdatedifference(to_date('2020-06-25'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying), to_date('2020-06-01'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying)) + '1'::numeric)))
  • Rows Removed by Filter: 9,493
48. 41,627.548 41,900.968 ↓ 5.4 9,857 8

Hash Join (cost=58.87..10,659.95 rows=1,809 width=320) (actual time=0.844..5,237.621 rows=9,857 loops=8)

  • Hash Cond: (c_1.relnamespace = n_1.oid)
49. 272.992 272.992 ↓ 1.8 9,857 8

Seq Scan on pg_class c_1 (cost=0.00..7,420.96 rows=5,447 width=8) (actual time=0.006..34.124 rows=9,857 loops=8)

  • Filter: ((relkind = 'S'::char) AND (pg_has_role(relowner, 'USAGE'::text) OR has_table_privilege(oid, 'SELECT, UPDATE'::text)))
  • Rows Removed by Filter: 63,124
50. 0.011 0.428 ↑ 4.1 71 1

Hash (cost=55.23..55.23 rows=291 width=4) (actual time=0.428..0.428 rows=71 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
51. 0.417 0.417 ↑ 4.1 71 1

Seq Scan on pg_namespace n_1 (cost=0.00..55.23 rows=291 width=4) (actual time=0.015..0.417 rows=71 loops=1)

  • Filter: (has_schema_privilege(oid, 'USAGE'::text) AND (nspname <> ALL ('{pg_catalog,information_schema,pg_toast}'::name[])))
  • Rows Removed by Filter: 805
52. 1,201.192 1,524.272 ↓ 1.1 364 8

Subquery Scan on *SELECT* 3 (cost=58.87..7,572.71 rows=324 width=0) (actual time=0.116..190.534 rows=364 loops=8)

  • Filter: ((rownum)::numeric < GREATEST('365'::numeric, (fgetdatedifference(to_date('2020-06-25'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying), to_date('2020-06-01'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying)) + '1'::numeric)))
  • Rows Removed by Filter: 8,297
53. 28.082 323.080 ↓ 8.9 8,661 8

Hash Join (cost=58.87..7,305.13 rows=973 width=184) (actual time=0.072..40.385 rows=8,661 loops=8)

  • Hash Cond: (c_2.relnamespace = n_2.oid)
54. 294.568 294.568 ↓ 3.0 8,735 8

Seq Scan on pg_class c_2 (cost=0.00..7,238.53 rows=2,930 width=8) (actual time=0.014..36.821 rows=8,735 loops=8)

  • Filter: ((NOT relispartition) AND (relkind = ANY ('{r,p}'::char[])) AND has_table_privilege(oid, 'SELECT, INSERT, UPDATE, DELETE, TRUNCATE, REFERENCES, TRIGGER'::text))
  • Rows Removed by Filter: 64,246
55. 0.010 0.430 ↑ 4.1 71 1

Hash (cost=55.23..55.23 rows=291 width=4) (actual time=0.429..0.430 rows=71 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
56. 0.420 0.420 ↑ 4.1 71 1

Seq Scan on pg_namespace n_2 (cost=0.00..55.23 rows=291 width=4) (actual time=0.019..0.420 rows=71 loops=1)

  • Filter: (has_schema_privilege(oid, 'USAGE'::text) AND (nspname <> ALL ('{pg_catalog,information_schema,pg_toast}'::name[])))
  • Rows Removed by Filter: 805
57. 0.456 0.656 ↑ 1.0 1 8

Subquery Scan on *SELECT* 4 (cost=0.28..9.60 rows=1 width=0) (actual time=0.081..0.082 rows=1 loops=8)

  • Filter: ((rownum)::numeric < GREATEST('365'::numeric, (fgetdatedifference(to_date('2020-06-25'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying), to_date('2020-06-01'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying)) + '1'::numeric)))
58. 0.064 0.200 ↑ 1.0 1 8

Nested Loop (cost=0.28..9.32 rows=1 width=192) (actual time=0.025..0.025 rows=1 loops=8)

59. 0.048 0.048 ↑ 1.0 1 8

Seq Scan on pg_synonym sy (cost=0.00..1.01 rows=1 width=25) (actual time=0.006..0.006 rows=1 loops=8)

60. 0.088 0.088 ↑ 1.0 1 8

Index Scan using pg_namespace_oid_index on pg_namespace pnname (cost=0.28..8.30 rows=1 width=68) (actual time=0.011..0.011 rows=1 loops=8)

  • Index Cond: (oid = sy.synnamespace)
  • Filter: ((nspname <> ALL ('{pg_catalog,information_schema,pg_toast}'::name[])) AND ((nspname = 'public'::name) OR pg_has_role(sy.synowner, 'USAGE'::text)))
61. 614.928 1,313.792 ↓ 2.1 364 8

Subquery Scan on *SELECT* 5 (cost=58.87..7,445.11 rows=174 width=0) (actual time=0.289..164.224 rows=364 loops=8)

  • Filter: ((rownum)::numeric < GREATEST('365'::numeric, (fgetdatedifference(to_date('2020-06-25'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying), to_date('2020-06-01'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying)) + '1'::numeric)))
  • Rows Removed by Filter: 4,155
62. 15.054 698.864 ↓ 8.7 4,519 8

Hash Join (cost=58.87..7,301.56 rows=522 width=192) (actual time=0.259..87.358 rows=4,519 loops=8)

  • Hash Cond: (c_3.relnamespace = n_3.oid)
63. 683.416 683.416 ↓ 2.9 4,637 8

Seq Scan on pg_class c_3 (cost=0.00..7,238.53 rows=1,572 width=4) (actual time=0.183..85.427 rows=4,637 loops=8)

  • Filter: (has_table_privilege(oid, 'SELECT, INSERT, UPDATE, DELETE, TRUNCATE, REFERENCES, TRIGGER'::text) AND (relkind = 'v'::char))
  • Rows Removed by Filter: 68,344
64. 0.010 0.394 ↑ 4.1 71 1

Hash (cost=55.23..55.23 rows=291 width=4) (actual time=0.394..0.394 rows=71 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
65. 0.384 0.384 ↑ 4.1 71 1

Seq Scan on pg_namespace n_3 (cost=0.00..55.23 rows=291 width=4) (actual time=0.012..0.384 rows=71 loops=1)

  • Filter: (has_schema_privilege(oid, 'USAGE'::text) AND (nspname <> ALL ('{pg_catalog,information_schema,pg_toast}'::name[])))
  • Rows Removed by Filter: 805
66. 90.624 151.472 ↓ 11.7 364 8

Subquery Scan on *SELECT* 6 (cost=60.64..1,432.62 rows=31 width=0) (actual time=1.283..18.934 rows=364 loops=8)

  • Filter: ((rownum)::numeric < GREATEST('365'::numeric, (fgetdatedifference(to_date('2020-06-25'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying), to_date('2020-06-01'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying)) + '1'::numeric)))
  • Rows Removed by Filter: 290
67. 0.856 60.848 ↓ 7.0 654 8

Nested Loop (cost=60.64..1,407.04 rows=93 width=192) (actual time=1.227..7.606 rows=654 loops=8)

68. 3.352 49.528 ↓ 7.0 654 8

Nested Loop (cost=60.35..916.93 rows=93 width=4) (actual time=1.210..6.191 rows=654 loops=8)

  • Join Filter: (pr.prolang = ln.oid)
  • Rows Removed by Join Filter: 1,962
69. 2.544 46.176 ↓ 7.0 654 8

Hash Join (cost=60.35..909.84 rows=93 width=8) (actual time=1.202..5.772 rows=654 loops=8)

  • Hash Cond: (pr.pronamespace = ns.oid)
70. 43.176 43.176 ↓ 3.0 1,053 8

Seq Scan on pg_proc pr (cost=0.00..848.58 rows=350 width=12) (actual time=1.140..5.397 rows=1,053 loops=8)

  • Filter: (has_function_privilege(oid, 'EXECUTE'::text) AND (protype = '1'::char))
  • Rows Removed by Filter: 4,658
71. 0.004 0.456 ↑ 46.8 5 1

Hash (cost=57.42..57.42 rows=234 width=4) (actual time=0.456..0.456 rows=5 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
72. 0.452 0.452 ↑ 46.8 5 1

Seq Scan on pg_namespace ns (cost=0.00..57.42 rows=234 width=4) (actual time=0.018..0.452 rows=5 loops=1)

  • Filter: (has_schema_privilege(oid, 'USAGE'::text) AND (nspparent = '0'::oid) AND (nspname <> ALL ('{pg_catalog,information_schema,pg_toast}'::name[])))
  • Rows Removed by Filter: 871
73. 0.000 0.000 ↑ 1.2 4 5,232

Materialize (cost=0.00..1.07 rows=5 width=4) (actual time=0.000..0.000 rows=4 loops=5,232)

74. 0.023 0.023 ↑ 1.2 4 1

Seq Scan on pg_language ln (cost=0.00..1.05 rows=5 width=4) (actual time=0.022..0.023 rows=4 loops=1)

75. 10.464 10.464 ↑ 1.0 1 5,232

Index Scan using pg_type_oid_index on pg_type tp_2 (cost=0.29..5.27 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=5,232)

  • Index Cond: (oid = pr.prorettype)
  • Filter: (typname <> 'trigger'::name)
76. 53.160 109.624 ↓ 3.2 364 8

Subquery Scan on *SELECT* 7 (cost=60.64..2,151.79 rows=112 width=0) (actual time=1.731..13.703 rows=364 loops=8)

  • Filter: ((rownum)::numeric < GREATEST('365'::numeric, (fgetdatedifference(to_date('2020-06-25'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying), to_date('2020-06-01'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying)) + '1'::numeric)))
  • Rows Removed by Filter: 5
77. 1.936 56.464 ↓ 1.1 369 8

Nested Loop (cost=60.64..2,059.67 rows=335 width=192) (actual time=1.679..7.058 rows=369 loops=8)

  • Join Filter: (pr_1.prolang = ln_1.oid)
  • Rows Removed by Join Filter: 789
78. 1.400 54.528 ↓ 1.1 369 8

Nested Loop (cost=60.64..2,036.83 rows=335 width=4) (actual time=1.674..6.816 rows=369 loops=8)

79. 2.915 47.192 ↓ 1.1 371 8

Hash Join (cost=60.35..912.23 rows=335 width=8) (actual time=1.406..5.899 rows=371 loops=8)

  • Hash Cond: (pr_1.pronamespace = ns_1.oid)
80. 43.880 43.880 ↓ 3.0 3,723 8

Seq Scan on pg_proc pr_1 (cost=0.00..848.58 rows=1,255 width=12) (actual time=0.004..5.485 rows=3,723 loops=8)

  • Filter: (has_function_privilege(oid, 'EXECUTE'::text) AND (protype = '0'::char))
  • Rows Removed by Filter: 1,988
81. 0.003 0.397 ↑ 46.8 5 1

Hash (cost=57.42..57.42 rows=234 width=4) (actual time=0.397..0.397 rows=5 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
82. 0.394 0.394 ↑ 46.8 5 1

Seq Scan on pg_namespace ns_1 (cost=0.00..57.42 rows=234 width=4) (actual time=0.014..0.394 rows=5 loops=1)

  • Filter: (has_schema_privilege(oid, 'USAGE'::text) AND (nspparent = '0'::oid) AND (nspname <> ALL ('{pg_catalog,information_schema,pg_toast}'::name[])))
  • Rows Removed by Filter: 871
83. 5.936 5.936 ↑ 1.0 1 2,968

Index Scan using pg_type_oid_index on pg_type tp_3 (cost=0.29..3.36 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=2,968)

  • Index Cond: (oid = pr_1.prorettype)
  • Filter: (typname <> 'trigger'::name)
  • Rows Removed by Filter: 0
84. 0.000 0.000 ↑ 1.7 3 2,952

Materialize (cost=0.00..1.07 rows=5 width=4) (actual time=0.000..0.000 rows=3 loops=2,952)

85. 0.010 0.010 ↑ 1.0 5 1

Seq Scan on pg_language ln_1 (cost=0.00..1.05 rows=5 width=4) (actual time=0.007..0.010 rows=5 loops=1)

86. 20.376 21.848 ↓ 24.7 148 8

Subquery Scan on *SELECT* 8 (cost=58.50..69.11 rows=6 width=0) (actual time=0.085..2.731 rows=148 loops=8)

  • Filter: ((rownum)::numeric < GREATEST('365'::numeric, (fgetdatedifference(to_date('2020-06-25'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying), to_date('2020-06-01'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying)) + '1'::numeric)))
87. 0.384 1.472 ↓ 7.8 148 8

Merge Join (cost=58.50..63.88 rows=19 width=192) (actual time=0.062..0.184 rows=148 loops=8)

  • Merge Cond: (ns_2.oid = pg_namespace_2.nspparent)
88. 0.568 0.568 ↑ 48.5 6 8

Index Scan using pg_namespace_oid_index on pg_namespace ns_2 (cost=0.28..114.60 rows=291 width=4) (actual time=0.021..0.071 rows=6 loops=8)

  • Filter: (has_schema_privilege(oid, 'USAGE'::text) AND (nspname <> ALL ('{pg_catalog,information_schema,pg_toast}'::name[])))
  • Rows Removed by Filter: 36
89. 0.250 0.520 ↓ 2.6 148 8

Sort (cost=57.99..58.13 rows=57 width=4) (actual time=0.038..0.065 rows=148 loops=8)

  • Sort Key: pg_namespace_2.nspparent
  • Sort Method: quicksort Memory: 31kB
90. 0.270 0.270 ↓ 2.6 148 1

Seq Scan on pg_namespace pg_namespace_2 (cost=0.00..56.33 rows=57 width=4) (actual time=0.010..0.270 rows=148 loops=1)

  • Filter: ((NOT nspcompoundtrigger) AND (nspparent <> '0'::oid) AND has_package_privilege(oid, 'EXECUTE'::text) AND (nspobjecttype = '0'::oid))
  • Rows Removed by Filter: 728
91. 11.472 29.400 ↓ 13.7 82 8

Subquery Scan on *SELECT* 9 (cost=60.65..71.26 rows=6 width=0) (actual time=2.185..3.675 rows=82 loops=8)

  • Filter: ((rownum)::numeric < GREATEST('365'::numeric, (fgetdatedifference(to_date('2020-06-25'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying), to_date('2020-06-01'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying)) + '1'::numeric)))
92. 0.224 17.928 ↓ 4.3 82 8

Merge Join (cost=60.65..66.03 rows=19 width=192) (actual time=2.155..2.241 rows=82 loops=8)

  • Merge Cond: (ns_3.oid = pg_namespace_3.nspparent)
93. 0.512 0.512 ↑ 48.5 6 8

Index Scan using pg_namespace_oid_index on pg_namespace ns_3 (cost=0.28..114.60 rows=291 width=4) (actual time=0.016..0.064 rows=6 loops=8)

  • Filter: (has_schema_privilege(oid, 'USAGE'::text) AND (nspname <> ALL ('{pg_catalog,information_schema,pg_toast}'::name[])))
  • Rows Removed by Filter: 36
94. 0.139 17.192 ↓ 1.5 82 8

Sort (cost=60.15..60.29 rows=56 width=4) (actual time=2.136..2.149 rows=82 loops=8)

  • Sort Key: pg_namespace_3.nspparent
  • Sort Method: quicksort Memory: 28kB
95. 17.053 17.053 ↓ 1.5 82 1

Seq Scan on pg_namespace pg_namespace_3 (cost=0.00..58.52 rows=56 width=4) (actual time=0.208..17.053 rows=82 loops=1)

  • Filter: ((NOT nspcompoundtrigger) AND (nspparent <> '0'::oid) AND (edb_get_packagebodydef(oid, false) IS NOT NULL) AND has_package_privilege(oid, 'EXECUTE'::text) AND (nspobjecttype = '0'::oid))
  • Rows Removed by Filter: 794
96. 119.800 126.536 ↓ 16.5 364 8

Subquery Scan on *SELECT* 10 (cost=5,535.37..5,573.46 rows=22 width=0) (actual time=0.479..15.817 rows=364 loops=8)

  • Filter: ((rownum)::numeric < GREATEST('365'::numeric, (fgetdatedifference(to_date('2020-06-25'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying), to_date('2020-06-01'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying)) + '1'::numeric)))
  • Rows Removed by Filter: 530
97. 1.992 6.736 ↓ 13.3 894 8

Merge Join (cost=5,535.37..5,555.03 rows=67 width=192) (actual time=0.451..0.842 rows=894 loops=8)

  • Merge Cond: (n_4.oid = c_4.relnamespace)
98. 0.488 0.488 ↑ 32.3 6 8

Index Scan using pg_namespace_oid_index on pg_namespace n_4 (cost=0.28..116.79 rows=194 width=4) (actual time=0.015..0.061 rows=6 loops=8)

  • Filter: ((NOT pg_is_other_temp_schema(oid)) AND has_schema_privilege(oid, 'USAGE'::text) AND (nspname <> ALL ('{pg_catalog,information_schema,pg_toast}'::name[])))
  • Rows Removed by Filter: 36
99. 1.187 4.256 ↓ 3.0 894 8

Sort (cost=5,535.09..5,535.84 rows=301 width=4) (actual time=0.399..0.532 rows=894 loops=8)

  • Sort Key: c_4.relnamespace
  • Sort Method: quicksort Memory: 66kB
100. 0.000 3.069 ↓ 3.0 894 1

Nested Loop (cost=0.70..5,522.70 rows=301 width=4) (actual time=0.086..3.069 rows=894 loops=1)

101. 0.358 0.358 ↓ 1.0 908 1

Index Scan using pg_trigger_tgconstraint_index on pg_trigger t (cost=0.29..108.07 rows=902 width=4) (actual time=0.023..0.358 rows=908 loops=1)

  • Index Cond: (tgconstraint = '0'::oid)
  • Filter: (((tgtype)::integer & 60) <> 0)
102. 2.724 2.724 ↑ 1.0 1 908

Index Scan using pg_class_oid_index on pg_class c_4 (cost=0.42..6.00 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=908)

  • Index Cond: (oid = t.tgrelid)
  • Filter: has_table_privilege(oid, 'SELECT, INSERT, UPDATE, DELETE, TRUNCATE, REFERENCES, TRIGGER'::text)
  • Rows Removed by Filter: 0
103. 8.984 662.504 ↓ 45.0 45 8

Subquery Scan on *SELECT* 11 (cost=114.22..7,451.17 rows=1 width=0) (actual time=0.627..82.813 rows=45 loops=8)

  • Filter: ((rownum)::numeric < GREATEST('365'::numeric, (fgetdatedifference(to_date('2020-06-25'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying), to_date('2020-06-01'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying)) + '1'::numeric)))
104. 123.624 653.520 ↓ 15.0 45 8

Nested Loop Left Join (cost=114.22..7,450.34 rows=3 width=192) (actual time=0.582..81.690 rows=45 loops=8)

  • Filter: ((c_5.relkind IS NULL) OR (c_5.relkind = 'c'::char))
  • Rows Removed by Filter: 23,125
105. 30.369 344.536 ↓ 11.7 23,170 8

Hash Join (cost=113.80..2,272.93 rows=1,983 width=4) (actual time=0.564..43.067 rows=23,170 loops=8)

  • Hash Cond: (t_1.typnamespace = n_5.oid)
106. 313.480 313.480 ↓ 2.7 31,964 8

Seq Scan on pg_type t_1 (cost=0.00..2,127.52 rows=11,983 width=8) (actual time=0.009..39.185 rows=31,964 loops=8)

  • Filter: (has_type_privilege(oid, 'USAGE'::text) AND ((typelem = '0'::oid) OR (typlen <> '-1'::integer) OR (typarray <> '0'::oid)))
  • Rows Removed by Filter: 13,541
107. 0.007 0.687 ↑ 8.1 18 1

Hash (cost=111.99..111.99 rows=145 width=4) (actual time=0.686..0.687 rows=18 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
108. 0.456 0.680 ↑ 8.1 18 1

Seq Scan on pg_namespace n_5 (cost=54.56..111.99 rows=145 width=4) (actual time=0.304..0.680 rows=18 loops=1)

  • Filter: ((NOT (hashed SubPlan 2)) AND has_schema_privilege(oid, 'USAGE'::text) AND (nspname <> ALL ('{pg_catalog,information_schema,pg_toast}'::name[])))
  • Rows Removed by Filter: 858
109.          

SubPlan (for Seq Scan)

110. 0.224 0.224 ↑ 1.1 156 1

Seq Scan on pg_namespace (cost=0.00..54.14 rows=170 width=64) (actual time=0.007..0.224 rows=156 loops=1)

  • Filter: ((NOT nspcompoundtrigger) AND (nspparent <> '0'::oid) AND (nspobjecttype = '0'::oid))
  • Rows Removed by Filter: 720
111. 185.360 185.360 ↑ 1.0 1 185,360

Index Scan using pg_class_oid_index on pg_class c_5 (cost=0.42..2.60 rows=1 width=5) (actual time=0.001..0.001 rows=1 loops=185,360)

  • Index Cond: (oid = t_1.typrelid)
112. 0.392 1.400 ↓ 2.0 2 8

Subquery Scan on *SELECT* 12 (cost=809.06..837.27 rows=1 width=0) (actual time=0.111..0.175 rows=2 loops=8)

  • Filter: ((rownum)::numeric < GREATEST('365'::numeric, (fgetdatedifference(to_date('2020-06-25'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying), to_date('2020-06-01'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying)) + '1'::numeric)))
113. 0.040 1.008 ↓ 2.0 2 8

Nested Loop Left Join (cost=809.06..836.99 rows=1 width=192) (actual time=0.080..0.126 rows=2 loops=8)

  • Filter: ((c_6.relkind IS NULL) OR (c_6.relkind = 'c'::char))
114. 0.048 0.904 ↑ 2.0 2 8

Merge Join (cost=808.64..826.55 rows=4 width=4) (actual time=0.073..0.113 rows=2 loops=8)

  • Merge Cond: (n_6.oid = t_2.typnamespace)
115. 0.489 0.672 ↑ 24.2 6 8

Index Scan using pg_namespace_oid_index on pg_namespace n_6 (cost=54.84..171.35 rows=145 width=4) (actual time=0.047..0.084 rows=6 loops=8)

  • Filter: ((NOT (hashed SubPlan 3)) AND has_schema_privilege(oid, 'USAGE'::text) AND (nspname <> ALL ('{pg_catalog,information_schema,pg_toast}'::name[])))
  • Rows Removed by Filter: 36
116.          

SubPlan (for Index Scan)

117. 0.183 0.183 ↑ 1.1 156 1

Seq Scan on pg_namespace pg_namespace_1 (cost=0.00..54.14 rows=170 width=64) (actual time=0.006..0.183 rows=156 loops=1)

  • Filter: ((NOT nspcompoundtrigger) AND (nspparent <> '0'::oid) AND (nspobjecttype = '0'::oid))
  • Rows Removed by Filter: 720
118. 0.017 0.184 ↑ 13.0 2 8

Sort (cost=753.80..753.87 rows=26 width=8) (actual time=0.023..0.023 rows=2 loops=8)

  • Sort Key: t_2.typnamespace
  • Sort Method: quicksort Memory: 25kB
119. 0.000 0.167 ↑ 13.0 2 1

Nested Loop (cost=0.29..753.19 rows=26 width=8) (actual time=0.028..0.167 rows=2 loops=1)

120. 0.084 0.084 ↑ 1.0 99 1

Seq Scan on pg_namespace pg_namespace_4 (cost=0.00..49.76 rows=99 width=4) (actual time=0.005..0.084 rows=99 loops=1)

  • Filter: (nspbodysrc IS NOT NULL)
  • Rows Removed by Filter: 777
121. 0.099 0.099 ↓ 0.0 0 99

Index Scan using pg_type_oid_index on pg_type t_2 (cost=0.29..7.11 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=99)

  • Index Cond: (oid = pg_namespace_4.nspobjecttype)
  • Filter: (has_type_privilege(oid, 'USAGE'::text) AND ((typelem = '0'::oid) OR (typlen <> '-1'::integer) OR (typarray <> '0'::oid)))
122. 0.064 0.064 ↑ 1.0 1 16

Index Scan using pg_class_oid_index on pg_class c_6 (cost=0.42..2.60 rows=1 width=5) (actual time=0.004..0.004 rows=1 loops=16)

  • Index Cond: (oid = t_2.typrelid)
123.          

SubPlan (for Nested Loop)

124. 14.560 14.560 ↑ 1.0 1 2,912

Seq Scan on dual (cost=0.00..1.03 rows=1 width=32) (actual time=0.004..0.005 rows=1 loops=2,912)

125. 0.034 54,391.134 ↓ 61.7 185 1

Append (cost=1.27..74.03 rows=3 width=216) (actual time=39.877..54,391.134 rows=185 loops=1)

126. 0.716 54,389.307 ↓ 90.5 181 1

Nested Loop Anti Join (cost=1.27..41.26 rows=2 width=216) (actual time=39.876..54,389.307 rows=181 loops=1)

127. 0.262 54,388.015 ↓ 96.0 192 1

Nested Loop (cost=0.84..31.89 rows=2 width=192) (actual time=39.843..54,388.015 rows=192 loops=1)

128. 0.131 54,387.369 ↓ 96.0 192 1

Nested Loop (cost=0.42..30.71 rows=2 width=168) (actual time=39.828..54,387.369 rows=192 loops=1)

129. 54,386.470 54,386.470 ↓ 96.0 192 1

CTE Scan on bewegdata tbw (cost=0.00..13.83 rows=2 width=138) (actual time=39.806..54,386.470 rows=192 loops=1)

  • Filter: ((missingdate >= to_date('2020-06-01'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying)) AND (missingdate <= to_date('2020-06-25'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying)))
  • Rows Removed by Filter: 252
130. 0.768 0.768 ↑ 1.0 1 192

Index Scan using xpkfall on tblfall tf (cost=0.42..8.44 rows=1 width=36) (actual time=0.004..0.004 rows=1 loops=192)

  • Index Cond: (fallid = tbw.fallid)
  • Filter: (stornierer IS NULL)
131. 0.384 0.384 ↑ 1.0 1 192

Index Scan using xpkpatient2 on tblpatient tp (cost=0.42..0.59 rows=1 width=36) (actual time=0.002..0.002 rows=1 loops=192)

  • Index Cond: (patientenid = tf.patientenid)
132. 0.576 0.576 ↓ 0.0 0 192

Index Only Scan using xpkeinstufung on tblppreinstufung tppr (cost=0.43..4.45 rows=1 width=14) (actual time=0.003..0.003 rows=0 loops=192)

  • Index Cond: ((fallid = tbw.fallid) AND (datum >= trunc(tbw.missingdate)) AND (datum <= (trunc(tbw.missingdate) + 0.99998842592592592593)))
  • Heap Fetches: 0
133. 0.021 1.793 ↓ 4.0 4 1

Nested Loop (cost=1.26..32.72 rows=1 width=216) (actual time=0.842..1.793 rows=4 loops=1)

134. 0.077 1.744 ↓ 4.0 4 1

Nested Loop Semi Join (cost=0.84..32.12 rows=1 width=168) (actual time=0.814..1.744 rows=4 loops=1)

  • Join Filter: ((tbw_1.fallid = tppr_1.fallid) AND (tppr_1.datum >= trunc(tbw_1.missingdate)) AND (tppr_1.datum <= (trunc(tbw_1.missingdate) + 0.99998842592592592593)))
  • Rows Removed by Join Filter: 116
135. 0.195 1.091 ↓ 96.0 192 1

Nested Loop (cost=0.42..30.71 rows=2 width=174) (actual time=0.122..1.091 rows=192 loops=1)

136. 0.512 0.512 ↓ 96.0 192 1

CTE Scan on bewegdata tbw_1 (cost=0.00..13.83 rows=2 width=138) (actual time=0.101..0.512 rows=192 loops=1)

  • Filter: ((missingdate >= to_date('2020-06-01'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying)) AND (missingdate <= to_date('2020-06-25'::character varying, 'YYYY-MM-DD hh24:mi:ss'::character varying)))
  • Rows Removed by Filter: 252
137. 0.384 0.384 ↑ 1.0 1 192

Index Scan using xpkfall on tblfall tf_1 (cost=0.42..8.44 rows=1 width=36) (actual time=0.002..0.002 rows=1 loops=192)

  • Index Cond: (fallid = tbw_1.fallid)
  • Filter: (stornierer IS NULL)
138. 0.576 0.576 ↑ 1.0 1 192

Index Scan using xie3tblppreinstufung on tblppreinstufung tppr_1 (cost=0.42..0.68 rows=1 width=14) (actual time=0.003..0.003 rows=1 loops=192)

  • Index Cond: (fallid = tf_1.fallid)
  • Filter: (((allgemeinepflege IS NULL) OR (speziellepflege IS NULL)) AND (basicvalue <> '110'::numeric) AND ((isadmission)::text = 'J'::text))
  • Rows Removed by Filter: 1
139. 0.028 0.028 ↑ 1.0 1 4

Index Scan using xpkpatient2 on tblpatient tp_1 (cost=0.42..0.59 rows=1 width=36) (actual time=0.007..0.007 rows=1 loops=4)

  • Index Cond: (patientenid = tf_1.patientenid)
Planning time : 13.870 ms
Execution time : 54,392.824 ms