explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XOUS

Settings
# exclusive inclusive rows x rows loops node
1. 3.180 398,486.165 ↑ 1.0 622 1

Sort (cost=5,371,539.86..5,371,541.47 rows=643 width=1,046) (actual time=398,486.023..398,486.165 rows=622 loops=1)

  • Sort Key: ei.created
  • Sort Method: quicksort Memory: 367kB
  • Buffers: shared hit=1201858, temp read=22595147 written=1489
2.          

CTE tmpdc1

3. 38.347 38.347 ↓ 1.0 20,196 1

Seq Scan on document document_1 (cost=0..6,572.61 rows=19,775 width=36) (actual time=0.042..38.347 rows=20,196 loops=1)

  • Filter: ((NOT document_1.istranslation) AND (NOT document_1.deleted) AND (document_1.flaggedfortranslation IS NOT NULL) AND ((document_1.flaggedfortranslation > document_1.translationcanceled) OR (document_1.translationcanceled IS NULL)))
  • Buffers: shared hit=4004
4.          

CTE tmpdc2

5. 7.516 98.422 ↓ 1.0 20,196 1

Sort (cost=168,806.46..168,855.9 rows=19,775 width=24) (actual time=96.598..98.422 rows=20,196 loops=1)

  • Sort Key: tmpdc1.flaggedfortranslation
  • Sort Method: quicksort Memory: 2314kB
  • Buffers: shared hit=84250
6. 50.514 90.906 ↓ 1.0 20,196 1

CTE Scan on tmpdc1 tmpdc1 (cost=0..167,395.38 rows=19,775 width=24) (actual time=0.06..90.906 rows=20,196 loops=1)

  • Buffers: shared hit=84250
7.          

SubPlan (for CTE Scan)

8. 40.392 40.392 ↑ 1.0 1 20,196

Index Scan using document_documenttype_instance_istranslation on document document_2 (cost=0.42..8.45 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=20,196)

  • Index Cond: ((document_2.eventinstance_id = tmpdc1.eventinstance_id) AND (document_2.documenttype_id = tmpdc1.documenttype_id) AND (document_2.instance = tmpdc1.instance) AND (document_2.istranslation = true))
  • Filter: (document_2.istranslation AND (NOT document_2.deleted))
  • Buffers: shared hit=80246
9.          

CTE eresrt

10. 4,574.481 4,594.654 ↓ 11.7 85,185 1

Bitmap Heap Scan on historyevent historyevent (cost=237.48..28,629.45 rows=7,252 width=38) (actual time=24.46..4,594.654 rows=85,185 loops=1)

  • Heap Blocks: exact=18818 lossy=60499
  • Buffers: shared hit=79904
11. 20.173 20.173 ↓ 11.8 85,227 1

Bitmap Index Scan on newhistoryevent_event_idx (cost=0..235.66 rows=7,252 width=0) (actual time=20.173..20.173 rows=85,227 loops=1)

  • Index Cond: (historyevent.event = ANY ('{eventRestartWorkflow,eventStartWorkflow,eventPulledBackToReview}'::text[]))
  • Buffers: shared hit=515
12.          

CTE eupsts

13. 11,700.090 11,754.584 ↓ 1,707.6 165,636 1

Bitmap Heap Scan on historyevent historyevent_1 (cost=78.58..9,668.34 rows=97 width=56) (actual time=61.448..11,754.584 rows=165,636 loops=1)

  • Filter: (((xpath('/auditHistoryRecord/eventStatus/text()'::text, (historyevent_1.xml)::xml, '{}'::text[]))[1])::text = ANY ('{"In Upload","In Review","In Second Review","In Adjudication","Waiting for Committee","In Committee",Completed,"In QC Committee"}'::text[]))
  • Heap Blocks: exact=32909 lossy=192707
  • Buffers: shared hit=227089
14. 54.494 54.494 ↓ 103.2 249,403 1

Bitmap Index Scan on newhistoryevent_event_idx (cost=0..78.55 rows=2,417 width=0) (actual time=54.494..54.494 rows=249,403 loops=1)

  • Index Cond: (historyevent_1.event = 'eventUpdateEventStatus'::text)
  • Buffers: shared hit=1473
15. 185.424 398,482.985 ↑ 1.0 622 1

Nested Loop (cost=7,045.85..5,157,783.57 rows=643 width=1,046) (actual time=17,258.129..398,482.985 rows=622 loops=1)

  • Buffers: shared hit=1201858, temp read=22595147 written=1489
16. 1.131 126.129 ↑ 1.0 622 1

Nested Loop (cost=7,045.57..53,080.86 rows=643 width=3,015) (actual time=33.991..126.129 rows=622 loops=1)

  • Buffers: shared hit=29478
17. 1.158 124.376 ↑ 1.0 622 1

Nested Loop (cost=7,045.28..52,542.7 rows=643 width=2,062) (actual time=33.989..124.376 rows=622 loops=1)

  • Buffers: shared hit=28329
18. 0.844 122.596 ↑ 1.0 622 1

Nested Loop (cost=7,044.99..52,004.53 rows=643 width=1,109) (actual time=33.987..122.596 rows=622 loops=1)

  • Buffers: shared hit=27180
19. 8.017 119.886 ↑ 1.0 622 1

Nested Loop (cost=7,044.7..51,466.37 rows=643 width=156) (actual time=33.982..119.886 rows=622 loops=1)

  • Buffers: shared hit=26031
20. 1.104 110.625 ↑ 1.0 622 1

Hash Join (cost=7,036.1..42,918.06 rows=643 width=148) (actual time=33.963..110.625 rows=622 loops=1)

  • Buffers: shared hit=23631
21. 1.266 80.422 ↑ 1.0 622 1

Hash Join (cost=858.21..36,737.48 rows=643 width=140) (actual time=4.838..80.422 rows=622 loops=1)

  • Buffers: shared hit=19627
22. 1.389 74.402 ↑ 1.0 622 1

Nested Loop (cost=19..35,895.52 rows=643 width=132) (actual time=0.061..74.402 rows=622 loops=1)

  • Buffers: shared hit=19209
23. 5.505 69.281 ↑ 1.0 622 1

Nested Loop (cost=18.72..35,591.4 rows=643 width=121) (actual time=0.057..69.281 rows=622 loops=1)

  • Buffers: shared hit=17343
24. 8.591 61.910 ↑ 1.0 622 1

Nested Loop (cost=9.99..24,817.94 rows=643 width=118) (actual time=0.049..61.91 rows=622 loops=1)

  • Buffers: shared hit=12992
25. 1.299 48.965 ↑ 1.0 622 1

Nested Loop (cost=1.27..14,044.47 rows=643 width=107) (actual time=0.034..48.965 rows=622 loops=1)

  • Buffers: shared hit=8635
26. 1.556 45.178 ↑ 1.0 622 1

Nested Loop (cost=1.12..13,931.87 rows=643 width=103) (actual time=0.031..45.178 rows=622 loops=1)

  • Buffers: shared hit=7391
27. 2.439 38.646 ↑ 1.0 622 1

Nested Loop (cost=0.7..8,554.52 rows=643 width=103) (actual time=0.025..38.646 rows=622 loops=1)

  • Buffers: shared hit=4900
28. 0.594 28.743 ↑ 1.0 622 1

Nested Loop (cost=0.28..3,354.78 rows=643 width=96) (actual time=0.02..28.743 rows=622 loops=1)

  • Buffers: shared hit=2402
29. 0.010 0.010 ↑ 1.0 1 1

Index Scan using trial_pkey on trial t (cost=0.28..8.3 rows=1 width=22) (actual time=0.008..0.01 rows=1 loops=1)

  • Index Cond: (t.id = '4684810092'::bigint)
  • Buffers: shared hit=4
30. 28.139 28.139 ↑ 1.0 622 1

Seq Scan on eventinstance ei (cost=0..3,340.05 rows=643 width=82) (actual time=0.011..28.139 rows=622 loops=1)

  • Filter: ((NOT ei.qc) AND (NOT ei.autoqc) AND (ei.trial_id = '4684810092'::bigint))
  • Buffers: shared hit=2398
31. 7.464 7.464 ↑ 1.0 1 622

Index Scan using trialsite_pkey on trialsite tsi (cost=0.42..8.08 rows=1 width=23) (actual time=0.011..0.012 rows=1 loops=622)

  • Index Cond: (tsi.id = ei.trialsite_id)
  • Buffers: shared hit=2498
32. 4.976 4.976 ↑ 1.0 1 622

Index Scan using trialsubject_pkey on trialsubject tsj (cost=0.42..8.35 rows=1 width=16) (actual time=0.007..0.008 rows=1 loops=622)

  • Index Cond: (tsj.id = ei.trialsubject_id)
  • Buffers: shared hit=2491
33. 2.488 2.488 ↑ 1.0 1 622

Index Scan using country_pkey on country cn (cost=0.15..0.17 rows=1 width=20) (actual time=0.003..0.004 rows=1 loops=622)

  • Index Cond: (tsi.country_id = cn.id)
  • Buffers: shared hit=1244
34. 0.000 4.354 ↑ 1.0 1 622

Index Scan using eventmetadata_unique_key_per_event on eventmetadata em_ir (cost=8.72..16.74 rows=1 width=27) (actual time=0.006..0.007 rows=1 loops=622)

  • Index Cond: ((em_ir.eventinstance_id = ei.id) AND (em_ir.trialmetadata_id = (SubPlan 66)))
  • Buffers: shared hit=2491
35.          

SubPlan (for Index Scan)

36. 5.598 5.598 ↑ 1.0 1 622

Index Scan using trialmetadata_unique_name_trial on trialmetadata trialmetadata (cost=0.28..8.3 rows=1 width=8) (actual time=0.009..0.009 rows=1 loops=622)

  • Index Cond: ((trialmetadata.trial_id = t.id) AND (trialmetadata.name = 'Event Date'::text))
  • Buffers: shared hit=1866
37. 0.000 1.866 ↑ 1.0 1 622

Index Scan using eventmetadata_unique_key_per_event on eventmetadata em_ev (cost=8.72..16.74 rows=1 width=27) (actual time=0.002..0.003 rows=1 loops=622)

  • Index Cond: ((em_ev.eventinstance_id = ei.id) AND (em_ev.trialmetadata_id = (SubPlan 67)))
  • Buffers: shared hit=2485
38.          

SubPlan (for Index Scan)

39. 3.110 3.110 ↑ 1.0 1 622

Index Scan using trialmetadata_unique_name_trial on trialmetadata trialmetadata_1 (cost=0.28..8.3 rows=1 width=8) (actual time=0.005..0.005 rows=1 loops=622)

  • Index Cond: ((trialmetadata_1.trial_id = t.id) AND (trialmetadata_1.name = 'agmetadata eventterm'::text))
  • Buffers: shared hit=1866
40. 3.732 3.732 ↑ 1.0 1 622

Index Scan using eventtype_pkey on eventtype et (cost=0.28..0.46 rows=1 width=27) (actual time=0.004..0.006 rows=1 loops=622)

  • Index Cond: (et.id = ei.eventtype_id)
  • Buffers: shared hit=1866
41. 0.244 4.754 ↑ 2.0 1,950 1

Hash (cost=791.09..791.09 rows=3,850 width=8) (actual time=4.754..4.754 rows=1,950 loops=1)

  • Buffers: shared hit=418
42. 0.998 4.510 ↑ 2.0 1,950 1

HashAggregate (cost=714.09..752.59 rows=3,850 width=8) (actual time=4.3..4.51 rows=1,950 loops=1)

  • Group Key: query.eventinstance_id
  • Buffers: shared hit=418
43. 3.512 3.512 ↓ 1.0 4,722 1

Seq Scan on query query (cost=0..702.48 rows=4,647 width=8) (actual time=0.009..3.512 rows=4,722 loops=1)

  • Filter: ((NOT query.deleted) AND query.open AND (query.querytype_id = ANY ('{1,2}'::bigint[])))
  • Buffers: shared hit=418
44. 0.094 29.099 ↑ 4.5 748 1

Hash (cost=6,135.58..6,135.58 rows=3,384 width=8) (actual time=29.099..29.099 rows=748 loops=1)

  • Buffers: shared hit=4004
45. 0.321 29.005 ↑ 4.5 748 1

HashAggregate (cost=6,067.9..6,101.74 rows=3,384 width=8) (actual time=28.925..29.005 rows=748 loops=1)

  • Group Key: document.eventinstance_id
  • Buffers: shared hit=4004
46. 28.684 28.684 ↑ 2.8 1,303 1

Seq Scan on document document (cost=0..6,058.89 rows=3,605 width=8) (actual time=0.024..28.684 rows=1,303 loops=1)

  • Filter: (document.intranslation AND (NOT document.deleted))
  • Buffers: shared hit=4004
47. 0.000 1.244 ↑ 1.0 1 622

Index Scan using finaloutcome_unique_versionnumber_per_event on finaloutcome fo (cost=8.6..13.28 rows=1 width=20) (actual time=0.002..0.002 rows=1 loops=622)

  • Index Cond: ((fo.eventinstance_id = ei.id) AND (fo.versionnumber = (SubPlan 69)))
  • Buffers: shared hit=1152
48.          

SubPlan (for Index Scan)

49. 1.244 4.976 ↑ 1.0 1 622

Result (cost=8.31..8.32 rows=1 width=4) (actual time=0.008..0.008 rows=1 loops=622)

  • Buffers: shared hit=1248
50.          

Initplan (for Result)

51. 0.622 3.732 ↑ 1.0 1 622

Limit (cost=0.29..8.31 rows=1 width=4) (actual time=0.006..0.006 rows=1 loops=622)

  • Buffers: shared hit=1248
52. 3.110 3.110 ↑ 1.0 1 622

Index Only Scan using finaloutcome_unique_versionnumber_per_event on finaloutcome finaloutcome (cost=0.29..8.31 rows=1 width=4) (actual time=0.005..0.005 rows=1 loops=622)

  • Index Cond: ((finaloutcome.eventinstance_id = ei.id) AND (finaloutcome.versionnumber IS NOT NULL))
  • Heap Fetches: 3
  • Buffers: shared hit=1248
53. 1.866 1.866 ↑ 1.0 1 622

Index Scan using finaloutcome_pkey on finaloutcome f1 (cost=0.29..0.83 rows=1 width=961) (actual time=0.003..0.003 rows=1 loops=622)

  • Index Cond: (f1.id = fo.id)
  • Buffers: shared hit=1149
54. 0.622 0.622 ↑ 1.0 1 622

Index Scan using finaloutcome_pkey on finaloutcome f1_1 (cost=0.29..0.83 rows=1 width=961) (actual time=0.001..0.001 rows=1 loops=622)

  • Index Cond: (f1_1.id = fo.id)
  • Buffers: shared hit=1149
55. 0.622 0.622 ↑ 1.0 1 622

Index Scan using finaloutcome_pkey on finaloutcome f1_2 (cost=0.29..0.83 rows=1 width=961) (actual time=0.001..0.001 rows=1 loops=622)

  • Index Cond: (f1_2.id = fo.id)
  • Buffers: shared hit=1149
56. 1.866 1.866 ↑ 1.0 1 622

Index Scan using finaloutcome_pkey on finaloutcome f1_3 (cost=0.29..0.83 rows=1 width=961) (actual time=0.001..0.003 rows=1 loops=622)

  • Index Cond: (f1_3.id = fo.id)
  • Buffers: shared hit=1149
57.          

SubPlan (for Nested Loop)

58. 0.000 31,826.496 ↑ 1.0 1 622

Limit (cost=166.03..166.03 rows=1 width=8) (actual time=51.167..51.168 rows=1 loops=622)

  • Buffers: shared hit=306993, temp read=925911 written=1487
59.          

Initplan (for Limit)

60. 1.244 9,761.668 ↑ 1.0 1 622

Limit (cost=163.35..163.35 rows=1 width=8) (actual time=15.693..15.694 rows=1 loops=622)

  • Buffers: shared hit=79904, temp read=293733 written=471
61. 2.488 9,760.424 ↑ 36.0 1 622

Sort (cost=163.35..163.44 rows=36 width=8) (actual time=15.692..15.692 rows=1 loops=622)

  • Sort Key: eresrt."time" DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=79904, temp read=293733 written=471
62. 9,757.936 9,757.936 ↑ 36.0 1 622

CTE Scan on eresrt eresrt (cost=0..163.17 rows=36 width=8) (actual time=10.846..15.688 rows=1 loops=622)

  • Filter: (eresrt.eiid = ei.id)
  • Buffers: shared hit=79904, temp read=293733 written=471
63. 4.976 31,824.630 ↑ 1.0 1 622

Sort (cost=2.68..2.68 rows=1 width=8) (actual time=51.165..51.165 rows=1 loops=622)

  • Sort Key: eupsts."time" DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=306993, temp read=925911 written=1487
64. 31,819.654 31,819.654 ↑ 1.0 1 622

CTE Scan on eupsts eupsts (cost=0..2.67 rows=1 width=8) (actual time=41.451..51.157 rows=1 loops=622)

  • Filter: ((eupsts."time" > $8) AND (eupsts.eiid = ei.id) AND (eupsts.eventstatus = 'In Adjudication'::text))
  • Buffers: shared hit=306993, temp read=925911 written=1487
65. 1.866 9,762.912 ↑ 1.0 1 622

Limit (cost=2.44..2.44 rows=1 width=8) (actual time=15.695..15.696 rows=1 loops=622)

  • Buffers: temp read=633196 written=1
66. 4.976 9,761.046 ↑ 1.0 1 622

Sort (cost=2.44..2.44 rows=1 width=8) (actual time=15.693..15.693 rows=1 loops=622)

  • Sort Key: eupsts_1."time" DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: temp read=633196 written=1
67. 9,756.070 9,756.070 ↑ 1.0 1 622

CTE Scan on eupsts eupsts_1 (cost=0..2.43 rows=1 width=8) (actual time=12.284..15.685 rows=1 loops=622)

  • Filter: ((eupsts_1.eiid = ei.id) AND (eupsts_1.eventstatus = 'In Upload'::text))
  • Buffers: temp read=633196 written=1
68. 13.684 2,167.048 ↑ 1.0 1 622

Aggregate (cost=759.38..759.39 rows=1 width=32) (actual time=3.484..3.484 rows=1 loops=622)

  • Buffers: shared hit=259996
69. 2,153.364 2,153.364 ↓ 1.5 3 622

Seq Scan on query q (cost=0..759.37 rows=2 width=8) (actual time=2.771..3.462 rows=3 loops=622)

  • Filter: ((NOT q.deleted) AND (q.eventinstance_id = ei.id) AND (q.querytype_id = 1))
  • Buffers: shared hit=259996
70. 8.708 2,087.432 ↑ 1.0 1 622

Aggregate (cost=759.38..759.39 rows=1 width=32) (actual time=3.356..3.356 rows=1 loops=622)

  • Buffers: shared hit=259996
71. 2,078.724 2,078.724 ↓ 1.5 3 622

Seq Scan on query q_1 (cost=0..759.37 rows=2 width=16) (actual time=2.706..3.342 rows=3 loops=622)

  • Filter: ((NOT q_1.deleted) AND (q_1.eventinstance_id = ei.id) AND (q_1.querytype_id = 1))
  • Buffers: shared hit=259996
72. 13.062 1,897.722 ↑ 1.0 1 622

Aggregate (cost=759.41..759.42 rows=1 width=32) (actual time=3.051..3.051 rows=1 loops=622)

  • Buffers: shared hit=259996
73. 1,884.660 1,884.660 ↓ 1.5 3 622

Seq Scan on query q_2 (cost=0..759.37 rows=2 width=16) (actual time=2.425..3.03 rows=3 loops=622)

  • Filter: ((NOT q_2.deleted) AND (q_2.eventinstance_id = ei.id) AND (q_2.querytype_id = 1))
  • Buffers: shared hit=259996
74. 3.110 1,056.778 ↑ 1.0 1 622

Aggregate (cost=445.44..445.44 rows=1 width=32) (actual time=1.699..1.699 rows=1 loops=622)

  • Buffers: shared hit=84250
75. 1,053.668 1,053.668 ↑ 49.5 2 622

CTE Scan on tmpdc2 tmpdc2 (cost=0..444.94 rows=99 width=8) (actual time=1.432..1.694 rows=2 loops=622)

  • Filter: (tmpdc2.eiid = ei.id)
  • Buffers: shared hit=84250
76. 2.488 934.866 ↑ 1.0 1 622

Aggregate (cost=445.44..445.44 rows=1 width=32) (actual time=1.503..1.503 rows=1 loops=622)

77. 932.378 932.378 ↑ 49.5 2 622

CTE Scan on tmpdc2 tmpdc2_1 (cost=0..444.94 rows=99 width=8) (actual time=1.247..1.499 rows=2 loops=622)

  • Filter: (tmpdc2_1.eiid = ei.id)
78. 4.354 928.024 ↑ 1.0 1 622

Aggregate (cost=446.92..446.93 rows=1 width=32) (actual time=1.492..1.492 rows=1 loops=622)

79. 923.670 923.670 ↑ 49.5 2 622

CTE Scan on tmpdc2 tmpdc2_2 (cost=0..444.94 rows=99 width=16) (actual time=1.234..1.485 rows=2 loops=622)

  • Filter: (tmpdc2_2.eiid = ei.id)
80. 0.000 15,180.532 ↑ 1.0 1 622

Limit (cost=166.03..166.03 rows=1 width=8) (actual time=24.405..24.406 rows=1 loops=622)

  • Buffers: temp read=927402 written=1
81.          

Initplan (for Limit)

82. 1.866 5,013.942 ↑ 1.0 1 622

Limit (cost=163.35..163.35 rows=1 width=8) (actual time=8.06..8.061 rows=1 loops=622)

  • Buffers: temp read=294206 written=1
83. 1.866 5,012.076 ↑ 36.0 1 622

Sort (cost=163.35..163.44 rows=36 width=8) (actual time=8.058..8.058 rows=1 loops=622)

  • Sort Key: eresrt_1."time" DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: temp read=294206 written=1
84. 5,010.210 5,010.210 ↑ 36.0 1 622

CTE Scan on eresrt eresrt_1 (cost=0..163.17 rows=36 width=8) (actual time=6.483..8.055 rows=1 loops=622)

  • Filter: (eresrt_1.eiid = ei.id)
  • Buffers: temp read=294206 written=1
85. 3.110 15,178.044 ↑ 1.0 1 622

Sort (cost=2.68..2.68 rows=1 width=8) (actual time=24.402..24.402 rows=1 loops=622)

  • Sort Key: eupsts_2."time" DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: temp read=927402 written=1
86. 15,174.934 15,174.934 ↑ 1.0 1 622

CTE Scan on eupsts eupsts_2 (cost=0..2.67 rows=1 width=8) (actual time=20.438..24.397 rows=1 loops=622)

  • Filter: ((eupsts_2."time" > $17) AND (eupsts_2.eiid = ei.id) AND (eupsts_2.eventstatus = 'In Review'::text))
  • Buffers: temp read=927402 written=1
87. 0.000 15,474.738 ↑ 1.0 1 622

Limit (cost=166.03..166.03 rows=1 width=8) (actual time=24.879..24.879 rows=1 loops=622)

  • Buffers: temp read=927402
88.          

Initplan (for Limit)

89. 1.244 4,957.962 ↑ 1.0 1 622

Limit (cost=163.35..163.35 rows=1 width=8) (actual time=7.97..7.971 rows=1 loops=622)

  • Buffers: temp read=294206
90. 2.488 4,956.718 ↑ 36.0 1 622

Sort (cost=163.35..163.44 rows=36 width=8) (actual time=7.969..7.969 rows=1 loops=622)

  • Sort Key: eresrt_2."time" DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: temp read=294206
91. 4,954.230 4,954.230 ↑ 36.0 1 622

CTE Scan on eresrt eresrt_2 (cost=0..163.17 rows=36 width=8) (actual time=6.409..7.965 rows=1 loops=622)

  • Filter: (eresrt_2.eiid = ei.id)
  • Buffers: temp read=294206
92. 3.732 15,472.872 ↑ 1.0 1 622

Sort (cost=2.68..2.68 rows=1 width=8) (actual time=24.876..24.876 rows=1 loops=622)

  • Sort Key: eupsts_3."time" DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: temp read=927402
93. 15,469.140 15,469.140 ↑ 1.0 1 622

CTE Scan on eupsts eupsts_3 (cost=0..2.67 rows=1 width=8) (actual time=20.73..24.87 rows=1 loops=622)

  • Filter: ((eupsts_3."time" > $19) AND (eupsts_3.eiid = ei.id) AND (eupsts_3.eventstatus = 'In Review'::text))
  • Buffers: temp read=927402
94. 1.866 10,069.558 ↑ 1.0 1 622

Limit (cost=2.44..2.44 rows=1 width=8) (actual time=16.188..16.189 rows=1 loops=622)

  • Buffers: temp read=633196
95. 4.354 10,067.692 ↑ 1.0 1 622

Sort (cost=2.44..2.44 rows=1 width=8) (actual time=16.186..16.186 rows=1 loops=622)

  • Sort Key: eupsts_4."time" DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: temp read=633196
96. 10,063.338 10,063.338 ↑ 1.0 1 622

CTE Scan on eupsts eupsts_4 (cost=0..2.43 rows=1 width=8) (actual time=12.668..16.179 rows=1 loops=622)

  • Filter: ((eupsts_4.eiid = ei.id) AND (eupsts_4.eventstatus = 'In Upload'::text))
  • Buffers: temp read=633196
97. 0.000 15,155.652 ↑ 1.0 1 622

Limit (cost=166.03..166.03 rows=1 width=8) (actual time=24.365..24.366 rows=1 loops=622)

  • Buffers: temp read=927402
98.          

Initplan (for Limit)

99. 1.866 5,015.186 ↑ 1.0 1 622

Limit (cost=163.35..163.35 rows=1 width=8) (actual time=8.062..8.063 rows=1 loops=622)

  • Buffers: temp read=294206
100. 1.866 5,013.320 ↑ 36.0 1 622

Sort (cost=163.35..163.44 rows=36 width=8) (actual time=8.06..8.06 rows=1 loops=622)

  • Sort Key: eresrt_3."time" DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: temp read=294206
101. 5,011.454 5,011.454 ↑ 36.0 1 622

CTE Scan on eresrt eresrt_3 (cost=0..163.17 rows=36 width=8) (actual time=6.482..8.057 rows=1 loops=622)

  • Filter: (eresrt_3.eiid = ei.id)
  • Buffers: temp read=294206
102. 3.732 15,153.786 ↑ 1.0 1 622

Sort (cost=2.68..2.68 rows=1 width=8) (actual time=24.363..24.363 rows=1 loops=622)

  • Sort Key: eupsts_5."time" DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: temp read=927402
103. 15,150.054 15,150.054 ↑ 1.0 1 622

CTE Scan on eupsts eupsts_5 (cost=0..2.67 rows=1 width=8) (actual time=21.633..24.357 rows=1 loops=622)

  • Filter: ((eupsts_5."time" > $22) AND (eupsts_5.eiid = ei.id) AND (eupsts_5.eventstatus = 'In Second Review'::text))
  • Buffers: temp read=927402
104. 0.000 15,457.944 ↑ 1.0 1 622

Limit (cost=166.03..166.03 rows=1 width=8) (actual time=24.851..24.852 rows=1 loops=622)

  • Buffers: temp read=927402
105.          

Initplan (for Limit)

106. 1.866 4,982.220 ↑ 1.0 1 622

Limit (cost=163.35..163.35 rows=1 width=8) (actual time=8.009..8.01 rows=1 loops=622)

  • Buffers: temp read=294206
107. 1.866 4,980.354 ↑ 36.0 1 622

Sort (cost=163.35..163.44 rows=36 width=8) (actual time=8.007..8.007 rows=1 loops=622)

  • Sort Key: eresrt_4."time" DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: temp read=294206
108. 4,978.488 4,978.488 ↑ 36.0 1 622

CTE Scan on eresrt eresrt_4 (cost=0..163.17 rows=36 width=8) (actual time=6.441..8.004 rows=1 loops=622)

  • Filter: (eresrt_4.eiid = ei.id)
  • Buffers: temp read=294206
109. 3.732 15,456.078 ↑ 1.0 1 622

Sort (cost=2.68..2.68 rows=1 width=8) (actual time=24.849..24.849 rows=1 loops=622)

  • Sort Key: eupsts_6."time" DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: temp read=927402
110. 15,452.346 15,452.346 ↑ 1.0 1 622

CTE Scan on eupsts eupsts_6 (cost=0..2.67 rows=1 width=8) (actual time=22.052..24.843 rows=1 loops=622)

  • Filter: ((eupsts_6."time" > $24) AND (eupsts_6.eiid = ei.id) AND (eupsts_6.eventstatus = 'In Second Review'::text))
  • Buffers: temp read=927402
111. 0.000 15,452.346 ↑ 1.0 1 622

Limit (cost=166.03..166.03 rows=1 width=8) (actual time=24.842..24.843 rows=1 loops=622)

  • Buffers: temp read=927402
112.          

Initplan (for Limit)

113. 1.244 4,955.474 ↑ 1.0 1 622

Limit (cost=163.35..163.35 rows=1 width=8) (actual time=7.967..7.967 rows=1 loops=622)

  • Buffers: temp read=294206
114. 1.866 4,954.230 ↑ 36.0 1 622

Sort (cost=163.35..163.44 rows=36 width=8) (actual time=7.965..7.965 rows=1 loops=622)

  • Sort Key: eresrt_5."time" DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: temp read=294206
115. 4,952.364 4,952.364 ↑ 36.0 1 622

CTE Scan on eresrt eresrt_5 (cost=0..163.17 rows=36 width=8) (actual time=6.407..7.962 rows=1 loops=622)

  • Filter: (eresrt_5.eiid = ei.id)
  • Buffers: temp read=294206
116. 4.976 15,450.480 ↑ 1.0 1 622

Sort (cost=2.68..2.68 rows=1 width=8) (actual time=24.839..24.84 rows=1 loops=622)

  • Sort Key: eupsts_7."time" DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: temp read=927402
117. 15,445.504 15,445.504 ↑ 1.0 1 622

CTE Scan on eupsts eupsts_7 (cost=0..2.67 rows=1 width=8) (actual time=20.717..24.832 rows=1 loops=622)

  • Filter: ((eupsts_7."time" > $26) AND (eupsts_7.eiid = ei.id) AND (eupsts_7.eventstatus = 'In Review'::text))
  • Buffers: temp read=927402
118. 0.000 15,117.710 ↑ 1.0 1 622

Limit (cost=166.03..166.03 rows=1 width=8) (actual time=24.304..24.305 rows=1 loops=622)

  • Buffers: temp read=927402
119.          

Initplan (for Limit)

120. 1.866 4,997.770 ↑ 1.0 1 622

Limit (cost=163.35..163.35 rows=1 width=8) (actual time=8.034..8.035 rows=1 loops=622)

  • Buffers: temp read=294206
121. 1.866 4,995.904 ↑ 36.0 1 622

Sort (cost=163.35..163.44 rows=36 width=8) (actual time=8.032..8.032 rows=1 loops=622)

  • Sort Key: eresrt_6."time" DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: temp read=294206
122. 4,994.038 4,994.038 ↑ 36.0 1 622

CTE Scan on eresrt eresrt_6 (cost=0..163.17 rows=36 width=8) (actual time=6.464..8.029 rows=1 loops=622)

  • Filter: (eresrt_6.eiid = ei.id)
  • Buffers: temp read=294206
123. 4.354 15,115.844 ↑ 1.0 1 622

Sort (cost=2.68..2.68 rows=1 width=8) (actual time=24.302..24.302 rows=1 loops=622)

  • Sort Key: eupsts_8."time" DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: temp read=927402
124. 15,111.490 15,111.490 ↑ 1.0 1 622

CTE Scan on eupsts eupsts_8 (cost=0..2.67 rows=1 width=8) (actual time=21.611..24.295 rows=1 loops=622)

  • Filter: ((eupsts_8."time" > $28) AND (eupsts_8.eiid = ei.id) AND (eupsts_8.eventstatus = 'In Adjudication'::text))
  • Buffers: temp read=927402
125. 0.000 15,433.064 ↑ 1.0 1 622

Limit (cost=166.03..166.03 rows=1 width=8) (actual time=24.812..24.812 rows=1 loops=622)

  • Buffers: temp read=927402
126.          

Initplan (for Limit)

127. 1.244 4,961.072 ↑ 1.0 1 622

Limit (cost=163.35..163.35 rows=1 width=8) (actual time=7.976..7.976 rows=1 loops=622)

  • Buffers: temp read=294206
128. 2.488 4,959.828 ↑ 36.0 1 622

Sort (cost=163.35..163.44 rows=36 width=8) (actual time=7.974..7.974 rows=1 loops=622)

  • Sort Key: eresrt_7."time" DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: temp read=294206
129. 4,957.340 4,957.340 ↑ 36.0 1 622

CTE Scan on eresrt eresrt_7 (cost=0..163.17 rows=36 width=8) (actual time=6.411..7.97 rows=1 loops=622)

  • Filter: (eresrt_7.eiid = ei.id)
  • Buffers: temp read=294206
130. 3.732 15,431.198 ↑ 1.0 1 622

Sort (cost=2.68..2.68 rows=1 width=8) (actual time=24.809..24.809 rows=1 loops=622)

  • Sort Key: eupsts_9."time" DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: temp read=927402
131. 15,427.466 15,427.466 ↑ 1.0 1 622

CTE Scan on eupsts eupsts_9 (cost=0..2.67 rows=1 width=8) (actual time=22.037..24.803 rows=1 loops=622)

  • Filter: ((eupsts_9."time" > $30) AND (eupsts_9.eiid = ei.id) AND (eupsts_9.eventstatus = 'In Adjudication'::text))
  • Buffers: temp read=927402
132. 0.000 15,429.332 ↑ 1.0 1 622

Limit (cost=166.03..166.03 rows=1 width=8) (actual time=24.805..24.806 rows=1 loops=622)

  • Buffers: temp read=927402
133.          

Initplan (for Limit)

134. 1.244 4,945.522 ↑ 1.0 1 622

Limit (cost=163.35..163.35 rows=1 width=8) (actual time=7.95..7.951 rows=1 loops=622)

  • Buffers: temp read=294206
135. 2.488 4,944.278 ↑ 36.0 1 622

Sort (cost=163.35..163.44 rows=36 width=8) (actual time=7.949..7.949 rows=1 loops=622)

  • Sort Key: eresrt_8."time" DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: temp read=294206
136. 4,941.790 4,941.790 ↑ 36.0 1 622

CTE Scan on eresrt eresrt_8 (cost=0..163.17 rows=36 width=8) (actual time=6.394..7.945 rows=1 loops=622)

  • Filter: (eresrt_8.eiid = ei.id)
  • Buffers: temp read=294206
137. 4.354 15,427.466 ↑ 1.0 1 622

Sort (cost=2.68..2.68 rows=1 width=8) (actual time=24.803..24.803 rows=1 loops=622)

  • Sort Key: eupsts_10."time" DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: temp read=927402
138. 15,423.112 15,423.112 ↑ 1.0 1 622

CTE Scan on eupsts eupsts_10 (cost=0..2.67 rows=1 width=8) (actual time=20.731..24.796 rows=1 loops=622)

  • Filter: ((eupsts_10."time" > $32) AND (eupsts_10.eiid = ei.id) AND (eupsts_10.eventstatus = 'In Review'::text))
  • Buffers: temp read=927402
139. 0.000 15,396.366 ↑ 1.0 1 622

Limit (cost=166.03..166.03 rows=1 width=8) (actual time=24.753..24.753 rows=1 loops=622)

  • Buffers: temp read=927402
140.          

Initplan (for Limit)

141. 1.244 4,956.718 ↑ 1.0 1 622

Limit (cost=163.35..163.35 rows=1 width=8) (actual time=7.969..7.969 rows=1 loops=622)

  • Buffers: temp read=294206
142. 1.866 4,955.474 ↑ 36.0 1 622

Sort (cost=163.35..163.44 rows=36 width=8) (actual time=7.967..7.967 rows=1 loops=622)

  • Sort Key: eresrt_9."time" DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: temp read=294206
143. 4,953.608 4,953.608 ↑ 36.0 1 622

CTE Scan on eresrt eresrt_9 (cost=0..163.17 rows=36 width=8) (actual time=6.409..7.964 rows=1 loops=622)

  • Filter: (eresrt_9.eiid = ei.id)
  • Buffers: temp read=294206
144. 3.732 15,394.500 ↑ 1.0 1 622

Sort (cost=2.68..2.68 rows=1 width=8) (actual time=24.75..24.75 rows=1 loops=622)

  • Sort Key: eupsts_11."time" DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: temp read=927402
145. 15,390.768 15,390.768 ↑ 1.0 1 622

CTE Scan on eupsts eupsts_11 (cost=0..2.67 rows=1 width=8) (actual time=21.981..24.744 rows=1 loops=622)

  • Filter: ((eupsts_11."time" > $34) AND (eupsts_11.eiid = ei.id) AND (eupsts_11.eventstatus = 'In Adjudication'::text))
  • Buffers: temp read=927402
146. 0.000 15,148.810 ↓ 0.0 0 622

Limit (cost=166.03..166.03 rows=1 width=8) (actual time=24.354..24.355 rows=0 loops=622)

  • Buffers: temp read=927402
147.          

Initplan (for Limit)

148. 1.866 5,130.256 ↑ 1.0 1 622

Limit (cost=163.35..163.35 rows=1 width=8) (actual time=8.247..8.248 rows=1 loops=622)

  • Buffers: temp read=294206
149. 1.866 5,128.390 ↑ 36.0 1 622

Sort (cost=163.35..163.44 rows=36 width=8) (actual time=8.245..8.245 rows=1 loops=622)

  • Sort Key: eresrt_10."time" DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: temp read=294206
150. 5,126.524 5,126.524 ↑ 36.0 1 622

CTE Scan on eresrt eresrt_10 (cost=0..163.17 rows=36 width=8) (actual time=6.634..8.242 rows=1 loops=622)

  • Filter: (eresrt_10.eiid = ei.id)
  • Buffers: temp read=294206
151. 3.732 15,146.944 ↓ 0.0 0 622

Sort (cost=2.68..2.68 rows=1 width=8) (actual time=24.352..24.352 rows=0 loops=622)

  • Sort Key: eupsts_12."time" DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: temp read=927402
152. 15,143.212 15,143.212 ↓ 0.0 0 622

CTE Scan on eupsts eupsts_12 (cost=0..2.67 rows=1 width=8) (actual time=23.671..24.346 rows=0 loops=622)

  • Filter: ((eupsts_12."time" > $36) AND (eupsts_12.eiid = ei.id) AND (eupsts_12.eventstatus = 'In Committee'::text))
  • Buffers: temp read=927402
153. 0.000 2,497.400 ↑ 1.0 1 100

Limit (cost=166.03..166.03 rows=1 width=8) (actual time=24.974..24.974 rows=1 loops=100)

  • Buffers: temp read=149100
154.          

Initplan (for Limit)

155. 0.300 808.700 ↑ 1.0 1 100

Limit (cost=163.35..163.35 rows=1 width=8) (actual time=8.086..8.087 rows=1 loops=100)

  • Buffers: temp read=47300
156. 0.300 808.400 ↑ 36.0 1 100

Sort (cost=163.35..163.44 rows=36 width=8) (actual time=8.084..8.084 rows=1 loops=100)

  • Sort Key: eresrt_11."time" DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: temp read=47300
157. 808.100 808.100 ↑ 36.0 1 100

CTE Scan on eresrt eresrt_11 (cost=0..163.17 rows=36 width=8) (actual time=5.956..8.081 rows=1 loops=100)

  • Filter: (eresrt_11.eiid = ei.id)
  • Buffers: temp read=47300
158. 0.700 2,497.100 ↑ 1.0 1 100

Sort (cost=2.68..2.68 rows=1 width=8) (actual time=24.971..24.971 rows=1 loops=100)

  • Sort Key: eupsts_13."time" DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: temp read=149100
159. 2,496.400 2,496.400 ↑ 1.0 1 100

CTE Scan on eupsts eupsts_13 (cost=0..2.67 rows=1 width=8) (actual time=20.64..24.964 rows=1 loops=100)

  • Filter: ((eupsts_13."time" > $38) AND (eupsts_13.eiid = ei.id) AND (eupsts_13.eventstatus = 'In Committee'::text))
  • Buffers: temp read=149100
160. 0.000 12,903.318 ↓ 0.0 0 522

Limit (cost=166.03..166.03 rows=1 width=8) (actual time=24.719..24.719 rows=0 loops=522)

  • Buffers: temp read=778302
161.          

Initplan (for Limit)

162. 1.044 4,242.294 ↑ 1.0 1 522

Limit (cost=163.35..163.35 rows=1 width=8) (actual time=8.126..8.127 rows=1 loops=522)

  • Buffers: temp read=246906
163. 2.088 4,241.250 ↑ 36.0 1 522

Sort (cost=163.35..163.44 rows=36 width=8) (actual time=8.125..8.125 rows=1 loops=522)

  • Sort Key: eresrt_12."time" DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: temp read=246906
164. 4,239.162 4,239.162 ↑ 36.0 1 522

CTE Scan on eresrt eresrt_12 (cost=0..163.17 rows=36 width=8) (actual time=6.642..8.121 rows=1 loops=522)

  • Filter: (eresrt_12.eiid = ei.id)
  • Buffers: temp read=246906
165. 3.132 12,902.274 ↓ 0.0 0 522

Sort (cost=2.68..2.68 rows=1 width=8) (actual time=24.717..24.717 rows=0 loops=522)

  • Sort Key: eupsts_14."time" DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: temp read=778302
166. 12,899.142 12,899.142 ↓ 0.0 0 522

CTE Scan on eupsts eupsts_14 (cost=0..2.67 rows=1 width=8) (actual time=24.711..24.711 rows=0 loops=522)

  • Filter: ((eupsts_14."time" > $40) AND (eupsts_14.eiid = ei.id) AND (eupsts_14.eventstatus = 'Waiting for Committee'::text))
  • Buffers: temp read=778302
167. 0.000 15,487.800 ↓ 0.0 0 622

Limit (cost=166.03..166.03 rows=1 width=8) (actual time=24.9..24.9 rows=0 loops=622)

  • Buffers: temp read=927402
168.          

Initplan (for Limit)

169. 1.866 4,982.220 ↑ 1.0 1 622

Limit (cost=163.35..163.35 rows=1 width=8) (actual time=8.009..8.01 rows=1 loops=622)

  • Buffers: temp read=294206
170. 2.488 4,980.354 ↑ 36.0 1 622

Sort (cost=163.35..163.44 rows=36 width=8) (actual time=8.007..8.007 rows=1 loops=622)

  • Sort Key: eresrt_13."time" DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: temp read=294206
171. 4,977.866 4,977.866 ↑ 36.0 1 622

CTE Scan on eresrt eresrt_13 (cost=0..163.17 rows=36 width=8) (actual time=6.442..8.003 rows=1 loops=622)

  • Filter: (eresrt_13.eiid = ei.id)
  • Buffers: temp read=294206
172. 3.732 15,486.556 ↓ 0.0 0 622

Sort (cost=2.68..2.68 rows=1 width=8) (actual time=24.898..24.898 rows=0 loops=622)

  • Sort Key: eupsts_15."time" DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: temp read=927402
173. 15,482.824 15,482.824 ↓ 0.0 0 622

CTE Scan on eupsts eupsts_15 (cost=0..2.67 rows=1 width=8) (actual time=24.191..24.892 rows=0 loops=622)

  • Filter: ((eupsts_15."time" > $42) AND (eupsts_15.eiid = ei.id) AND (eupsts_15.eventstatus = 'In Committee'::text))
  • Buffers: temp read=927402
174. 0.000 15,433.686 ↓ 0.0 0 622

Limit (cost=166.03..166.03 rows=1 width=8) (actual time=24.812..24.813 rows=0 loops=622)

  • Buffers: temp read=927402
175.          

Initplan (for Limit)

176. 1.244 4,954.230 ↑ 1.0 1 622

Limit (cost=163.35..163.35 rows=1 width=8) (actual time=7.965..7.965 rows=1 loops=622)

  • Buffers: temp read=294206
177. 2.488 4,952.986 ↑ 36.0 1 622

Sort (cost=163.35..163.44 rows=36 width=8) (actual time=7.963..7.963 rows=1 loops=622)

  • Sort Key: eresrt_14."time" DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: temp read=294206
178. 4,950.498 4,950.498 ↑ 36.0 1 622

CTE Scan on eresrt eresrt_14 (cost=0..163.17 rows=36 width=8) (actual time=6.405..7.959 rows=1 loops=622)

  • Filter: (eresrt_14.eiid = ei.id)
  • Buffers: temp read=294206
179. 3.732 15,431.820 ↓ 0.0 0 622

Sort (cost=2.68..2.68 rows=1 width=8) (actual time=24.81..24.81 rows=0 loops=622)

  • Sort Key: eupsts_16."time" DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: temp read=927402
180. 15,428.088 15,428.088 ↓ 0.0 0 622

CTE Scan on eupsts eupsts_16 (cost=0..2.67 rows=1 width=8) (actual time=24.102..24.804 rows=0 loops=622)

  • Filter: ((eupsts_16."time" > $44) AND (eupsts_16.eiid = ei.id) AND (eupsts_16.eventstatus = 'Waiting for Committee'::text))
  • Buffers: temp read=927402
181. 0.000 15,119.576 ↓ 0.0 0 622

Limit (cost=166.03..166.03 rows=1 width=8) (actual time=24.308..24.308 rows=0 loops=622)

  • Buffers: temp read=927402
182.          

Initplan (for Limit)

183. 1.244 4,999.014 ↑ 1.0 1 622

Limit (cost=163.35..163.35 rows=1 width=8) (actual time=8.037..8.037 rows=1 loops=622)

  • Buffers: temp read=294206
184. 2.488 4,997.770 ↑ 36.0 1 622

Sort (cost=163.35..163.44 rows=36 width=8) (actual time=8.035..8.035 rows=1 loops=622)

  • Sort Key: eresrt_15."time" DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: temp read=294206
185. 4,995.282 4,995.282 ↑ 36.0 1 622

CTE Scan on eresrt eresrt_15 (cost=0..163.17 rows=36 width=8) (actual time=6.463..8.031 rows=1 loops=622)

  • Filter: (eresrt_15.eiid = ei.id)
  • Buffers: temp read=294206
186. 3.732 15,118.332 ↓ 0.0 0 622

Sort (cost=2.68..2.68 rows=1 width=8) (actual time=24.306..24.306 rows=0 loops=622)

  • Sort Key: eupsts_17."time" DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: temp read=927402
187. 15,114.600 15,114.600 ↓ 0.0 0 622

CTE Scan on eupsts eupsts_17 (cost=0..2.67 rows=1 width=8) (actual time=24.3..24.3 rows=0 loops=622)

  • Filter: ((eupsts_17."time" > $46) AND (eupsts_17.eiid = ei.id) AND (eupsts_17.eventstatus = 'In QC Committee'::text))
  • Buffers: temp read=927402
188. 0.000 15,118.954 ↑ 1.0 1 622

Limit (cost=166.03..166.03 rows=1 width=8) (actual time=24.306..24.307 rows=1 loops=622)

  • Buffers: temp read=927402
189.          

Initplan (for Limit)

190. 1.244 4,988.440 ↑ 1.0 1 622

Limit (cost=163.35..163.35 rows=1 width=8) (actual time=8.02..8.02 rows=1 loops=622)

  • Buffers: temp read=294206
191. 1.866 4,987.196 ↑ 36.0 1 622

Sort (cost=163.35..163.44 rows=36 width=8) (actual time=8.018..8.018 rows=1 loops=622)

  • Sort Key: eresrt_16."time" DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: temp read=294206
192. 4,985.330 4,985.330 ↑ 36.0 1 622

CTE Scan on eresrt eresrt_16 (cost=0..163.17 rows=36 width=8) (actual time=6.448..8.015 rows=1 loops=622)

  • Filter: (eresrt_16.eiid = ei.id)
  • Buffers: temp read=294206
193. 4.354 15,117.088 ↑ 1.0 1 622

Sort (cost=2.68..2.68 rows=1 width=8) (actual time=24.304..24.304 rows=1 loops=622)

  • Sort Key: eupsts_18."time" DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: temp read=927402
194. 15,112.734 15,112.734 ↑ 1.0 1 622

CTE Scan on eupsts eupsts_18 (cost=0..2.67 rows=1 width=8) (actual time=21.793..24.297 rows=1 loops=622)

  • Filter: ((eupsts_18."time" > $48) AND (eupsts_18.eiid = ei.id) AND (eupsts_18.eventstatus = 'Completed'::text))
  • Buffers: temp read=927402
195. 0.000 15,438.040 ↑ 1.0 1 622

Limit (cost=166.03..166.03 rows=1 width=8) (actual time=24.82..24.82 rows=1 loops=622)

  • Buffers: temp read=927402
196.          

Initplan (for Limit)

197. 1.244 4,957.962 ↑ 1.0 1 622

Limit (cost=163.35..163.35 rows=1 width=8) (actual time=7.971..7.971 rows=1 loops=622)

  • Buffers: temp read=294206
198. 2.488 4,956.718 ↑ 36.0 1 622

Sort (cost=163.35..163.44 rows=36 width=8) (actual time=7.969..7.969 rows=1 loops=622)

  • Sort Key: eresrt_17."time" DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: temp read=294206
199. 4,954.230 4,954.230 ↑ 36.0 1 622

CTE Scan on eresrt eresrt_17 (cost=0..163.17 rows=36 width=8) (actual time=6.412..7.965 rows=1 loops=622)

  • Filter: (eresrt_17.eiid = ei.id)
  • Buffers: temp read=294206
200. 3.732 15,436.174 ↑ 1.0 1 622

Sort (cost=2.68..2.68 rows=1 width=8) (actual time=24.817..24.817 rows=1 loops=622)

  • Sort Key: eupsts_19."time" DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: temp read=927402
201. 15,432.442 15,432.442 ↑ 1.0 1 622

CTE Scan on eupsts eupsts_19 (cost=0..2.67 rows=1 width=8) (actual time=22.235..24.811 rows=1 loops=622)

  • Filter: ((eupsts_19."time" > $50) AND (eupsts_19.eiid = ei.id) AND (eupsts_19.eventstatus = 'Completed'::text))
  • Buffers: temp read=927402
202. 0.000 15,446.126 ↑ 1.0 1 622

Limit (cost=166.03..166.03 rows=1 width=8) (actual time=24.833..24.833 rows=1 loops=622)

  • Buffers: temp read=927402
203.          

Initplan (for Limit)

204. 1.866 4,960.450 ↑ 1.0 1 622

Limit (cost=163.35..163.35 rows=1 width=8) (actual time=7.974..7.975 rows=1 loops=622)

  • Buffers: temp read=294206
205. 1.866 4,958.584 ↑ 36.0 1 622

Sort (cost=163.35..163.44 rows=36 width=8) (actual time=7.972..7.972 rows=1 loops=622)

  • Sort Key: eresrt_18."time" DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: temp read=294206
206. 4,956.718 4,956.718 ↑ 36.0 1 622

CTE Scan on eresrt eresrt_18 (cost=0..163.17 rows=36 width=8) (actual time=6.414..7.969 rows=1 loops=622)

  • Filter: (eresrt_18.eiid = ei.id)
  • Buffers: temp read=294206
207. 3.732 15,444.260 ↑ 1.0 1 622

Sort (cost=2.68..2.68 rows=1 width=8) (actual time=24.83..24.83 rows=1 loops=622)

  • Sort Key: eupsts_20."time" DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: temp read=927402
208. 15,440.528 15,440.528 ↑ 1.0 1 622

CTE Scan on eupsts eupsts_20 (cost=0..2.67 rows=1 width=8) (actual time=22.056..24.824 rows=1 loops=622)

  • Filter: ((eupsts_20."time" > $52) AND (eupsts_20.eiid = ei.id) AND (eupsts_20.eventstatus = 'In Adjudication'::text))
  • Buffers: temp read=927402
209. 0.000 15,420.624 ↑ 1.0 1 622

Limit (cost=166.03..166.03 rows=1 width=8) (actual time=24.792..24.792 rows=1 loops=622)

  • Buffers: temp read=927402
210.          

Initplan (for Limit)

211. 1.244 4,953.608 ↑ 1.0 1 622

Limit (cost=163.35..163.35 rows=1 width=8) (actual time=7.964..7.964 rows=1 loops=622)

  • Buffers: temp read=294206
212. 2.488 4,952.364 ↑ 36.0 1 622

Sort (cost=163.35..163.44 rows=36 width=8) (actual time=7.962..7.962 rows=1 loops=622)

  • Sort Key: eresrt_19."time" DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: temp read=294206
213. 4,949.876 4,949.876 ↑ 36.0 1 622

CTE Scan on eresrt eresrt_19 (cost=0..163.17 rows=36 width=8) (actual time=6.406..7.958 rows=1 loops=622)

  • Filter: (eresrt_19.eiid = ei.id)
  • Buffers: temp read=294206
214. 3.732 15,418.758 ↑ 1.0 1 622

Sort (cost=2.68..2.68 rows=1 width=8) (actual time=24.789..24.789 rows=1 loops=622)

  • Sort Key: eupsts_21."time" DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: temp read=927402
215. 15,415.026 15,415.026 ↑ 1.0 1 622

CTE Scan on eupsts eupsts_21 (cost=0..2.67 rows=1 width=8) (actual time=22.212..24.783 rows=1 loops=622)

  • Filter: ((eupsts_21."time" > $54) AND (eupsts_21.eiid = ei.id) AND (eupsts_21.eventstatus = 'Completed'::text))
  • Buffers: temp read=927402
216. 0.000 15,430.576 ↓ 0.0 0 622

Limit (cost=166.03..166.03 rows=1 width=8) (actual time=24.808..24.808 rows=0 loops=622)

  • Buffers: temp read=927402
217.          

Initplan (for Limit)

218. 1.244 4,957.962 ↑ 1.0 1 622

Limit (cost=163.35..163.35 rows=1 width=8) (actual time=7.97..7.971 rows=1 loops=622)

  • Buffers: temp read=294206
219. 2.488 4,956.718 ↑ 36.0 1 622

Sort (cost=163.35..163.44 rows=36 width=8) (actual time=7.968..7.969 rows=1 loops=622)

  • Sort Key: eresrt_20."time" DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: temp read=294206
220. 4,954.230 4,954.230 ↑ 36.0 1 622

CTE Scan on eresrt eresrt_20 (cost=0..163.17 rows=36 width=8) (actual time=6.413..7.965 rows=1 loops=622)

  • Filter: (eresrt_20.eiid = ei.id)
  • Buffers: temp read=294206
221. 3.732 15,429.332 ↓ 0.0 0 622

Sort (cost=2.68..2.68 rows=1 width=8) (actual time=24.806..24.806 rows=0 loops=622)

  • Sort Key: eupsts_22."time" DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: temp read=927402
222. 15,425.600 15,425.600 ↓ 0.0 0 622

CTE Scan on eupsts eupsts_22 (cost=0..2.67 rows=1 width=8) (actual time=24.097..24.8 rows=0 loops=622)

  • Filter: ((eupsts_22."time" > $56) AND (eupsts_22.eiid = ei.id) AND (eupsts_22.eventstatus = 'In Committee'::text))
  • Buffers: temp read=927402
223. 0.000 15,220.340 ↑ 1.0 1 622

Limit (cost=166.03..166.03 rows=1 width=8) (actual time=24.469..24.47 rows=1 loops=622)

  • Buffers: temp read=927402
224.          

Initplan (for Limit)

225. 1.244 4,926.862 ↑ 1.0 1 622

Limit (cost=163.35..163.35 rows=1 width=8) (actual time=7.921..7.921 rows=1 loops=622)

  • Buffers: temp read=294206
226. 2.488 4,925.618 ↑ 36.0 1 622

Sort (cost=163.35..163.44 rows=36 width=8) (actual time=7.919..7.919 rows=1 loops=622)

  • Sort Key: eresrt_21."time" DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: temp read=294206
227. 4,923.130 4,923.130 ↑ 36.0 1 622

CTE Scan on eresrt eresrt_21 (cost=0..163.17 rows=36 width=8) (actual time=6.37..7.915 rows=1 loops=622)

  • Filter: (eresrt_21.eiid = ei.id)
  • Buffers: temp read=294206
228. 4.354 15,218.474 ↑ 1.0 1 622

Sort (cost=2.68..2.68 rows=1 width=8) (actual time=24.467..24.467 rows=1 loops=622)

  • Sort Key: eupsts_23."time" DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: temp read=927402
229. 15,214.120 15,214.120 ↑ 1.0 1 622

CTE Scan on eupsts eupsts_23 (cost=0..2.67 rows=1 width=8) (actual time=21.931..24.46 rows=1 loops=622)

  • Filter: ((eupsts_23."time" > $58) AND (eupsts_23.eiid = ei.id) AND (eupsts_23.eventstatus = 'Completed'::text))
  • Buffers: temp read=927402
230. 0.000 15,216.608 ↓ 0.0 0 622

Limit (cost=166.03..166.03 rows=1 width=8) (actual time=24.464..24.464 rows=0 loops=622)

  • Buffers: temp read=927402
231.          

Initplan (for Limit)

232. 1.244 4,931.838 ↑ 1.0 1 622

Limit (cost=163.35..163.35 rows=1 width=8) (actual time=7.929..7.929 rows=1 loops=622)

  • Buffers: temp read=294206
233. 2.488 4,930.594 ↑ 36.0 1 622

Sort (cost=163.35..163.44 rows=36 width=8) (actual time=7.927..7.927 rows=1 loops=622)

  • Sort Key: eresrt_22."time" DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: temp read=294206
234. 4,928.106 4,928.106 ↑ 36.0 1 622

CTE Scan on eresrt eresrt_22 (cost=0..163.17 rows=36 width=8) (actual time=6.377..7.923 rows=1 loops=622)

  • Filter: (eresrt_22.eiid = ei.id)
  • Buffers: temp read=294206
235. 3.110 15,215.364 ↓ 0.0 0 622

Sort (cost=2.68..2.68 rows=1 width=8) (actual time=24.462..24.462 rows=0 loops=622)

  • Sort Key: eupsts_24."time" DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: temp read=927402
236. 15,212.254 15,212.254 ↓ 0.0 0 622

CTE Scan on eupsts eupsts_24 (cost=0..2.67 rows=1 width=8) (actual time=24.457..24.457 rows=0 loops=622)

  • Filter: ((eupsts_24."time" > $60) AND (eupsts_24.eiid = ei.id) AND (eupsts_24.eventstatus = 'In QC Committee'::text))
  • Buffers: temp read=927402
237. 0.000 0.000 ↓ 0.0 0 0

Limit (cost=166.03..166.03 rows=1 width=8) (never executed)

238.          

Initplan (for Limit)

239. 0.000 0.000 ↓ 0.0 0 0

Limit (cost=163.35..163.35 rows=1 width=8) (never executed)

240. 0.000 0.000 ↓ 0.0 0 0

Sort (cost=163.35..163.44 rows=36 width=8) (never executed)

  • Sort Key: eresrt_23."time" DESC
241. 0.000 0.000 ↓ 0.0 0 0

CTE Scan on eresrt eresrt_23 (cost=0..163.17 rows=36 width=8) (never executed)

  • Filter: (eresrt_23.eiid = ei.id)
242. 0.000 0.000 ↓ 0.0 0 0

Sort (cost=2.68..2.68 rows=1 width=8) (never executed)

  • Sort Key: eupsts_25."time" DESC
243. 0.000 0.000 ↓ 0.0 0 0

CTE Scan on eupsts eupsts_25 (cost=0..2.67 rows=1 width=8) (never executed)

  • Filter: ((eupsts_25."time" > $62) AND (eupsts_25.eiid = ei.id) AND (eupsts_25.eventstatus = 'Completed'::text))
244. 0.000 0.000 ↓ 0.0 0 0

Limit (cost=166.03..166.03 rows=1 width=8) (never executed)

245.          

Initplan (for Limit)

246. 0.000 0.000 ↓ 0.0 0 0

Limit (cost=163.35..163.35 rows=1 width=8) (never executed)

247. 0.000 0.000 ↓ 0.0 0 0

Sort (cost=163.35..163.44 rows=36 width=8) (never executed)

  • Sort Key: eresrt_24."time" DESC
248. 0.000 0.000 ↓ 0.0 0 0

CTE Scan on eresrt eresrt_24 (cost=0..163.17 rows=36 width=8) (never executed)

  • Filter: (eresrt_24.eiid = ei.id)
249. 0.000 0.000 ↓ 0.0 0 0

Sort (cost=2.68..2.68 rows=1 width=8) (never executed)

  • Sort Key: eupsts_26."time" DESC
250. 0.000 0.000 ↓ 0.0 0 0

CTE Scan on eupsts eupsts_26 (cost=0..2.67 rows=1 width=8) (never executed)

  • Filter: ((eupsts_26."time" > $64) AND (eupsts_26.eiid = ei.id) AND (eupsts_26.eventstatus = 'In QC Committee'::text))
251. 0.000 15,459.188 ↑ 1.0 1 622

Limit (cost=166.03..166.03 rows=1 width=8) (actual time=24.854..24.854 rows=1 loops=622)

  • Buffers: temp read=927402
252.          

Initplan (for Limit)

253. 1.244 4,989.062 ↑ 1.0 1 622

Limit (cost=163.35..163.35 rows=1 width=8) (actual time=8.021..8.021 rows=1 loops=622)

  • Buffers: temp read=294206
254. 2.488 4,987.818 ↑ 36.0 1 622

Sort (cost=163.35..163.44 rows=36 width=8) (actual time=8.019..8.019 rows=1 loops=622)

  • Sort Key: eresrt_25."time" DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: temp read=294206
255. 4,985.330 4,985.330 ↑ 36.0 1 622

CTE Scan on eresrt eresrt_25 (cost=0..163.17 rows=36 width=8) (actual time=6.452..8.015 rows=1 loops=622)

  • Filter: (eresrt_25.eiid = ei.id)
  • Buffers: temp read=294206
256. 3.732 15,457.322 ↑ 1.0 1 622

Sort (cost=2.68..2.68 rows=1 width=8) (actual time=24.851..24.851 rows=1 loops=622)

  • Sort Key: eupsts_27."time" DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: temp read=927402
257. 15,453.590 15,453.590 ↑ 1.0 1 622

CTE Scan on eupsts eupsts_27 (cost=0..2.67 rows=1 width=8) (actual time=22.27..24.845 rows=1 loops=622)

  • Filter: ((eupsts_27."time" > $66) AND (eupsts_27.eiid = ei.id) AND (eupsts_27.eventstatus = 'Completed'::text))
  • Buffers: temp read=927402
Planning time : 5.709 ms
Execution time : 398,489.601 ms