explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZBeu : PW

Settings
# exclusive inclusive rows x rows loops node
1. 12.367 13,166.161 ↓ 123.5 6,421 1

Sort (cost=20,282.93..20,283.06 rows=52 width=292) (actual time=13,164.357..13,166.161 rows=6,421 loops=1)

  • Sort Key: "*SELECT* 1".modifiedonutc, "*SELECT* 1".action, "*SELECT* 1".validuntilutc, "*SELECT* 1".entryid, ((ui.externalid)::character varying(255)) COLLATE "en_US", "*SELECT* 1".entrydate
  • Sort Method: quicksort Memory: 1898kB
  • Buffers: shared hit=1300925 read=29046
2. 12.413 13,153.794 ↓ 123.5 6,421 1

Nested Loop (cost=1.11..20,281.45 rows=52 width=292) (actual time=2,164.968..13,153.794 rows=6,421 loops=1)

  • Buffers: shared hit=1300909 read=29046
3. 3.232 13,102.855 ↓ 123.5 6,421 1

Append (cost=0.82..20,181.20 rows=52 width=285) (actual time=2,163.699..13,102.855 rows=6,421 loops=1)

  • Buffers: shared hit=1281712 read=28980
4. 0.001 0.003 ↓ 0.0 0 1

Subquery Scan on *SELECT* 1 (cost=0.82..20.76 rows=1 width=309) (actual time=0.003..0.003 rows=0 loops=1)

5. 0.001 0.002 ↓ 0.0 0 1

Nested Loop (cost=0.82..20.75 rows=1 width=177) (actual time=0.002..0.002 rows=0 loops=1)

6. 0.000 0.001 ↓ 0.0 0 1

Nested Loop (cost=0.41..15.93 rows=1 width=108) (actual time=0.001..0.001 rows=0 loops=1)

7. 0.000 0.001 ↓ 0.0 0 1

Nested Loop (cost=0.12..12.53 rows=1 width=92) (actual time=0.001..0.001 rows=0 loops=1)

  • Join Filter: (at.rootid = allocatedtime.rootid)
8. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on allocatedtime at (cost=0.00..10.38 rows=1 width=76) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: ((fromtimestamputc >= '2019-03-04 23:00:00'::timestamp without time zone) AND (fromtimestamputc < '2019-03-05 23:00:00'::timestamp without time zone) AND (CASE WHEN (parentid IS NULL) THEN 100 ELSE 101 EN (...)
9. 0.000 0.000 ↓ 0.0 0

Index Scan using ixallocatedtimerootid on allocatedtime (cost=0.12..2.14 rows=1 width=32) (never executed)

10. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtsuseridstartdateenddate on timesheet ts (cost=0.28..3.39 rows=2 width=28) (never executed)

  • Index Cond: ((userid = at.userid) AND (at.entrydate >= startdate) AND (at.entrydate <= enddate))
11. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtpsstimesheetid on timesheetpolicysettingssnapshot tsformat (cost=0.42..4.81 rows=1 width=101) (never executed)

  • Index Cond: (timesheetid = ts.id)
  • Filter: ((upper(uri) <> 'URN:REPLICON:POLICY:TIMESHEET:TIMESHEET-FORMAT:GEN4-TIMESHEET'::text) AND (upper(key) = 'URN:REPLICON:POLICY:TIMESHEET:TIMESHEET-FORMAT'::text))
12. 0.000 0.008 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2 (cost=0.42..15.88 rows=1 width=256) (actual time=0.008..0.008 rows=0 loops=1)

13. 0.007 0.008 ↓ 0.0 0 1

Result (cost=0.42..15.87 rows=1 width=52) (actual time=0.008..0.008 rows=0 loops=1)

  • One-Time Filter: (102 = ANY ('{100,101,102}'::integer[]))
14. 0.001 0.001 ↓ 0.0 0 1

Nested Loop (cost=0.42..15.87 rows=1 width=52) (actual time=0.001..0.001 rows=0 loops=1)

15. 0.000 0.000 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.14..12.46 rows=1 width=52) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: (child_at.id IS NULL)
16. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on allocatedtime at_1 (cost=0.00..10.30 rows=1 width=52) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: ((totimestamputc IS NOT NULL) AND (totimestamputc >= '2019-03-04 23:00:00'::timestamp without time zone) AND (totimestamputc < '2019-03-05 23:00:00'::timestamp without time zone))
17. 0.000 0.000 ↓ 0.0 0

Index Scan using uixallocatedtime_parent on allocatedtime child_at (cost=0.14..2.16 rows=1 width=32) (never executed)

  • Index Cond: (parentid = at_1.id)
18. 0.000 0.000 ↓ 0.0 0

Index Only Scan using ixtsuseridstartdateenddate on timesheet ts_1 (cost=0.28..3.39 rows=2 width=12) (never executed)

  • Index Cond: ((userid = at_1.userid) AND (startdate <= at_1.entrydate) AND (enddate >= at_1.entrydate))
  • Heap Fetches: 0
19. 0.952 4,814.507 ↓ 1,393.0 1,393 1

Subquery Scan on *SELECT* 3 (cost=65.08..327.38 rows=1 width=284) (actual time=2,163.687..4,814.507 rows=1,393 loops=1)

  • Buffers: shared hit=121152 read=9828
20. 2.491 4,813.555 ↓ 1,393.0 1,393 1

Nested Loop Left Join (cost=65.08..327.37 rows=1 width=132) (actual time=2,163.686..4,813.555 rows=1,393 loops=1)

  • Buffers: shared hit=121152 read=9828
21. 3.008 4,804.099 ↓ 1,393.0 1,393 1

Nested Loop Left Join (cost=64.53..324.78 rows=1 width=148) (actual time=2,163.675..4,804.099 rows=1,393 loops=1)

  • Buffers: shared hit=115576 read=9828
22. 2.313 4,789.947 ↓ 1,393.0 1,393 1

Nested Loop Left Join (cost=63.97..322.20 rows=1 width=148) (actual time=2,163.663..4,789.947 rows=1,393 loops=1)

  • Buffers: shared hit=108609 read=9825
23. 4.900 3,284.587 ↓ 1,393.0 1,393 1

Nested Loop (cost=63.42..319.61 rows=1 width=88) (actual time=2,161.833..3,284.587 rows=1,393 loops=1)

  • Buffers: shared hit=104232 read=7213
24. 2.843 1,911.111 ↓ 58.6 3,456 1

Nested Loop (cost=63.00..65.04 rows=59 width=12) (actual time=1,869.005..1,911.111 rows=3,456 loops=1)

  • Buffers: shared hit=10449 read=3571
25. 8.666 1,870.252 ↓ 3,456.0 3,456 1

HashAggregate (cost=62.72..62.73 rows=1 width=16) (actual time=1,868.013..1,870.252 rows=3,456 loops=1)

  • Group Key: timesheetpolicysettingssnapshot.timesheetid
  • Buffers: shared hit=13 read=3509
26. 1,861.586 1,861.586 ↓ 58.6 3,456 1

Index Scan using ixtspss2key on timesheetpolicysettingssnapshot (cost=0.55..62.57 rows=59 width=16) (actual time=5.311..1,861.586 rows=3,456 loops=1)

  • Index Cond: ((upper(key) = 'URN:REPLICON:POLICY:TIMESHEET:TIMESHEET-FORMAT'::text) AND (upper(uri) = 'URN:REPLICON:POLICY:TIMESHEET:TIMESHEET-FORMAT:GEN4-TIMESHEET'::text))
  • Buffers: shared hit=13 read=3509
27. 38.016 38.016 ↑ 1.0 1 3,456

Index Scan using timesheet_pkey on timesheet ts_2 (cost=0.28..2.30 rows=1 width=28) (actual time=0.010..0.011 rows=1 loops=3,456)

  • Index Cond: (id = timesheetpolicysettingssnapshot.timesheetid)
  • Buffers: shared hit=10436 read=62
28. 1,368.576 1,368.576 ↓ 0.0 0 3,456

Index Scan using ixter2userid on timeentryrevision rev (cost=0.42..4.30 rows=1 width=88) (actual time=0.362..0.396 rows=0 loops=3,456)

  • Index Cond: ((userid = ts_2.userid) AND (entrydate >= ts_2.startdate) AND (entrydate <= ts_2.enddate))
  • Filter: ((fromtimestamputc >= '2019-03-04 23:00:00'::timestamp without time zone) AND (fromtimestamputc < '2019-03-05 23:00:00'::timestamp without time zone) AND (CASE WHEN (previousrevisionid IS NULL) THEN (...)
  • Rows Removed by Filter: 33
  • Buffers: shared hit=93783 read=3642
29. 1,503.047 1,503.047 ↑ 1.0 1 1,393

Index Scan using uix4rakv_uniquekeyuri on revisionauditkeyvalue effectiveuser (cost=0.56..2.57 rows=1 width=76) (actual time=1.068..1.079 rows=1 loops=1,393)

  • Index Cond: ((revisionauditid = rev.openingauditid) AND (upper(keyuri) = 'URN:REPLICON:REVISION-AUDIT-KEY:EFFECTIVE-USER'::text))
  • Buffers: shared hit=4377 read=2612
30. 11.144 11.144 ↑ 1.0 1 1,393

Index Scan using uix4rakv_uniquekeyuri on revisionauditkeyvalue actualuser (cost=0.56..2.57 rows=1 width=16) (actual time=0.008..0.008 rows=1 loops=1,393)

  • Index Cond: ((revisionauditid = rev.openingauditid) AND (upper(keyuri) = 'URN:REPLICON:REVISION-AUDIT-KEY:ACTUAL-USER'::text))
  • Buffers: shared hit=6967 read=3
31. 6.965 6.965 ↓ 0.0 0 1,393

Index Scan using uix4rakv_uniquekeyuri on revisionauditkeyvalue changereason (cost=0.56..2.57 rows=1 width=16) (actual time=0.005..0.005 rows=0 loops=1,393)

  • Index Cond: ((revisionauditid = rev.openingauditid) AND (upper(keyuri) = 'URN:REPLICON:REVISION-AUDIT-KEY:COMMENT'::text))
  • Buffers: shared hit=5576
32. 1.796 473.419 ↓ 3,562.0 3,562 1

Subquery Scan on *SELECT* 4 (cost=395.55..3,605.63 rows=1 width=284) (actual time=227.596..473.419 rows=3,562 loops=1)

  • Buffers: shared hit=172582 read=688
33. 2.657 471.623 ↓ 3,562.0 3,562 1

Result (cost=395.55..3,605.62 rows=1 width=132) (actual time=227.595..471.623 rows=3,562 loops=1)

  • One-Time Filter: (101 = ANY ('{100,101,102}'::integer[]))
  • Buffers: shared hit=172582 read=688
34. 4.830 468.966 ↓ 3,562.0 3,562 1

Nested Loop Left Join (cost=395.55..3,605.62 rows=1 width=132) (actual time=227.581..468.966 rows=3,562 loops=1)

  • Buffers: shared hit=172582 read=688
35. 4.208 453.450 ↓ 3,562.0 3,562 1

Nested Loop Left Join (cost=394.99..3,603.13 rows=1 width=148) (actual time=227.575..453.450 rows=3,562 loops=1)

  • Buffers: shared hit=154755 read=688
36. 5.748 431.432 ↓ 3,562.0 3,562 1

Nested Loop Anti Join (cost=394.44..3,600.64 rows=1 width=88) (actual time=227.554..431.432 rows=3,562 loops=1)

  • Buffers: shared hit=136876 read=688
37. 8.942 259.778 ↓ 54.1 6,381 1

Hash Join (cost=394.02..3,500.14 rows=118 width=104) (actual time=225.996..259.778 rows=6,381 loops=1)

  • Hash Cond: (mdrev.timeentryid = rev_1.timeentryid)
  • Join Filter: ((rev_1.fromtimestamputc <= mdrev.fromtimestamputc) AND ((rev_1.totimestamputc IS NULL) OR (rev_1.totimestamputc > mdrev.fromtimestamputc)))
  • Rows Removed by Join Filter: 13459
  • Buffers: shared hit=111715 read=317
38. 26.398 26.398 ↑ 1.1 6,381 1

Index Scan using ixtemr2fromtimestamputc on timeentrymetadatarevision mdrev (cost=0.42..2,965.73 rows=7,028 width=80) (actual time=1.478..26.398 rows=6,381 loops=1)

  • Index Cond: ((fromtimestamputc >= '2019-03-04 23:00:00'::timestamp without time zone) AND (fromtimestamputc < '2019-03-05 23:00:00'::timestamp without time zone))
  • Buffers: shared hit=270 read=317
39. 45.996 224.438 ↓ 21.0 114,248 1

Hash (cost=325.59..325.59 rows=5,441 width=40) (actual time=224.438..224.438 rows=114,248 loops=1)

  • Buckets: 131072 (originally 8192) Batches: 1 (originally 1) Memory Usage: 9156kB
  • Buffers: shared hit=111445
40. 65.179 178.442 ↓ 21.0 114,248 1

Nested Loop (cost=63.42..325.59 rows=5,441 width=40) (actual time=6.191..178.442 rows=114,248 loops=1)

  • Buffers: shared hit=111445
41. 5.117 19.951 ↓ 58.6 3,456 1

Nested Loop (cost=63.00..65.04 rows=59 width=12) (actual time=6.181..19.951 rows=3,456 loops=1)

  • Buffers: shared hit=14020
42. 7.922 7.922 ↓ 3,456.0 3,456 1

HashAggregate (cost=62.72..62.73 rows=1 width=16) (actual time=6.172..7.922 rows=3,456 loops=1)

  • Group Key: timesheetpolicysettingssnapshot_1.timesheetid
  • Buffers: shared hit=3522
  • -> Index Scan using ixtspss2key on timesheetpolicysettingssnapshot timesheetpolicysettingssnapshot_1 (cost=0.55..62.57 rows=59 width=16) (actual time=0.031..4.201 rows=3456 loops=1 (...)
  • Index Cond: ((upper(key) = 'URN:REPLICON:POLICY:TIMESHEET:TIMESHEET-FORMAT'::text) AND (upper(uri) = 'URN:REPLICON:POLICY:TIMESHEET:TIMESHEET-FORMAT:GEN4-TIMESHEET'::text))
  • Buffers: shared hit=3522
43. 6.912 6.912 ↑ 1.0 1 3,456

Index Scan using timesheet_pkey on timesheet ts_3 (cost=0.28..2.30 rows=1 width=28) (actual time=0.002..0.002 rows=1 loops=3,456)

  • Index Cond: (id = timesheetpolicysettingssnapshot_1.timesheetid)
  • Buffers: shared hit=10498
44. 93.312 93.312 ↑ 2.7 33 3,456

Index Scan using ixter2userid on timeentryrevision rev_1 (cost=0.42..3.53 rows=89 width=40) (actual time=0.004..0.027 rows=33 loops=3,456)

  • Index Cond: ((userid = ts_3.userid) AND (entrydate >= ts_3.startdate) AND (entrydate <= ts_3.enddate))
  • Buffers: shared hit=97425
45. 165.906 165.906 ↓ 0.0 0 6,381

Index Scan using timeentryrevision_singleinitialrevision on timeentryrevision (cost=0.42..0.84 rows=1 width=24) (actual time=0.026..0.026 rows=0 loops=6,381)

  • Index Cond: (timeentryid = mdrev.timeentryid)
  • Filter: (fromtimestamputc = mdrev.fromtimestamputc)
  • Rows Removed by Filter: 1
  • Buffers: shared hit=25161 read=371
46. 17.810 17.810 ↑ 1.0 1 3,562

Index Scan using uix4rakv_uniquekeyuri on revisionauditkeyvalue effectiveuser_1 (cost=0.56..2.48 rows=1 width=76) (actual time=0.005..0.005 rows=1 loops=3,562)

  • Index Cond: ((revisionauditid = mdrev.openingauditid) AND (upper(keyuri) = 'URN:REPLICON:REVISION-AUDIT-KEY:EFFECTIVE-USER'::text))
  • Buffers: shared hit=17879
47. 10.686 10.686 ↑ 1.0 1 3,562

Index Scan using uix4rakv_uniquekeyuri on revisionauditkeyvalue actualuser_1 (cost=0.56..2.48 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=3,562)

  • Index Cond: ((revisionauditid = mdrev.openingauditid) AND (upper(keyuri) = 'URN:REPLICON:REVISION-AUDIT-KEY:ACTUAL-USER'::text))
  • Buffers: shared hit=17827
48. 0.246 6,877.095 ↓ 8.1 317 1

Subquery Scan on *SELECT* 5 (cost=66.21..4,950.19 rows=39 width=284) (actual time=1,925.624..6,877.095 rows=317 loops=1)

  • Buffers: shared hit=738762 read=16664
49. 0.463 6,876.849 ↓ 8.1 317 1

Result (cost=66.21..4,949.80 rows=39 width=108) (actual time=1,925.622..6,876.849 rows=317 loops=1)

  • One-Time Filter: (101 = ANY ('{100,101,102}'::integer[]))
  • Buffers: shared hit=738762 read=16664
50. 0.498 6,876.386 ↓ 8.1 317 1

Nested Loop Anti Join (cost=66.21..4,949.80 rows=39 width=108) (actual time=1,925.611..6,876.386 rows=317 loops=1)

  • Buffers: shared hit=738762 read=16664
51. 0.582 6,743.699 ↓ 8.1 317 1

Nested Loop Left Join (cost=65.37..4,880.76 rows=39 width=124) (actual time=1,924.067..6,743.699 rows=317 loops=1)

  • Buffers: shared hit=735553 read=16417
52. 0.615 6,737.728 ↓ 8.1 317 1

Nested Loop Left Join (cost=64.82..4,782.13 rows=39 width=140) (actual time=1,924.057..6,737.728 rows=317 loops=1)

  • Buffers: shared hit=733958 read=16409
53. 3.002 6,603.022 ↓ 8.1 317 1

Nested Loop Anti Join (cost=64.26..4,683.50 rows=39 width=80) (actual time=1,922.083..6,603.022 rows=317 loops=1)

  • Buffers: shared hit=732583 read=16187
54. 31.978 6,586.020 ↓ 53.0 3,500 1

Nested Loop (cost=63.84..4,470.41 rows=66 width=140) (actual time=725.108..6,586.020 rows=3,500 loops=1)

  • Buffers: shared hit=718255 read=16187
55. 84.205 270.402 ↓ 21.0 114,248 1

Nested Loop (cost=63.42..325.59 rows=5,441 width=40) (actual time=6.173..270.402 rows=114,248 loops=1)

  • Buffers: shared hit=111445
56. 4.331 30.677 ↓ 58.6 3,456 1

Nested Loop (cost=63.00..65.04 rows=59 width=12) (actual time=6.161..30.677 rows=3,456 loops=1)

  • Buffers: shared hit=14020
57. 9.066 9.066 ↓ 3,456.0 3,456 1

HashAggregate (cost=62.72..62.73 rows=1 width=16) (actual time=6.151..9.066 rows=3,456 loops=1)

  • Group Key: timesheetpolicysettingssnapshot_2.timesheetid
  • Buffers: shared hit=3522
  • -> Index Scan using ixtspss2key on timesheetpolicysettingssnapshot timesheetpolicysettingssnapshot_2 (cost=0.55..62.57 rows=59 width=16) (actual time=0.030..4.201 rows=3456 loops=1 (...)
  • Index Cond: ((upper(key) = 'URN:REPLICON:POLICY:TIMESHEET:TIMESHEET-FORMAT'::text) AND (upper(uri) = 'URN:REPLICON:POLICY:TIMESHEET:TIMESHEET-FORMAT:GEN4-TIMESHEET'::text))
  • Buffers: shared hit=3522
58. 17.280 17.280 ↑ 1.0 1 3,456

Index Scan using timesheet_pkey on timesheet ts_4 (cost=0.28..2.30 rows=1 width=28) (actual time=0.004..0.005 rows=1 loops=3,456)

  • Index Cond: (id = timesheetpolicysettingssnapshot_2.timesheetid)
  • Buffers: shared hit=10498
59. 155.520 155.520 ↑ 2.7 33 3,456

Index Scan using ixter2userid on timeentryrevision rev_2 (cost=0.42..3.53 rows=89 width=40) (actual time=0.007..0.045 rows=33 loops=3,456)

  • Index Cond: ((userid = ts_4.userid) AND (entrydate >= ts_4.startdate) AND (entrydate <= ts_4.enddate))
  • Buffers: shared hit=97425
60. 6,283.640 6,283.640 ↓ 0.0 0 114,248

Index Scan using ixtemrtimeentryid on timeentrymetadatarevision mdrev_1 (cost=0.42..0.75 rows=1 width=116) (actual time=0.054..0.055 rows=0 loops=114,248)

  • Index Cond: (timeentryid = rev_2.timeentryid)
  • Filter: ((totimestamputc IS NOT NULL) AND (totimestamputc >= '2019-03-04 23:00:00'::timestamp without time zone) AND (totimestamputc < '2019-03-05 23:00:00'::timestamp without time zone) AND (re (...)
  • Rows Removed by Filter: 10
  • Buffers: shared hit=606810 read=16187
61. 14.000 14.000 ↑ 1.0 1 3,500

Index Scan using ixtemr2fromtimestamputc on timeentrymetadatarevision (cost=0.42..3.22 rows=1 width=84) (actual time=0.004..0.004 rows=1 loops=3,500)

  • Index Cond: (fromtimestamputc = mdrev_1.totimestamputc)
  • Filter: ((timeentryid = mdrev_1.timeentryid) AND (key = mdrev_1.key) AND (openingauditid = mdrev_1.closingauditid))
  • Rows Removed by Filter: 2
  • Buffers: shared hit=14328
62. 134.091 134.091 ↑ 1.0 1 317

Index Scan using uix4rakv_uniquekeyuri on revisionauditkeyvalue effectiveuser_2 (cost=0.56..2.52 rows=1 width=76) (actual time=0.421..0.423 rows=1 loops=317)

  • Index Cond: ((revisionauditid = mdrev_1.openingauditid) AND (upper(keyuri) = 'URN:REPLICON:REVISION-AUDIT-KEY:EFFECTIVE-USER'::text))
  • Buffers: shared hit=1375 read=222
63. 5.389 5.389 ↑ 1.0 1 317

Index Scan using uix4rakv_uniquekeyuri on revisionauditkeyvalue actualuser_2 (cost=0.56..2.52 rows=1 width=16) (actual time=0.016..0.017 rows=1 loops=317)

  • Index Cond: ((revisionauditid = mdrev_1.openingauditid) AND (upper(keyuri) = 'URN:REPLICON:REVISION-AUDIT-KEY:ACTUAL-USER'::text))
  • Buffers: shared hit=1595 read=8
64. 0.951 132.189 ↓ 0.0 0 317

Nested Loop Left Join (cost=0.83..1.74 rows=1 width=24) (actual time=0.417..0.417 rows=0 loops=317)

  • Filter: (child_rev.id IS NULL)
  • Rows Removed by Filter: 1
  • Buffers: shared hit=3209 read=247
65. 75.763 75.763 ↑ 1.0 1 317

Index Scan using ixtertimeentryid on timeentryrevision rev_3 (cost=0.42..1.26 rows=1 width=40) (actual time=0.232..0.239 rows=1 loops=317)

  • Index Cond: (timeentryid = mdrev_1.timeentryid)
  • Filter: (totimestamputc = mdrev_1.totimestamputc)
  • Rows Removed by Filter: 4
  • Buffers: shared hit=2053 read=132
66. 55.475 55.475 ↑ 1.0 1 317

Index Scan using timeentryrevision_uniquepreviousrevisionid on timeentryrevision child_rev (cost=0.42..0.47 rows=1 width=32) (actual time=0.174..0.175 rows=1 loops=317)

  • Index Cond: (previousrevisionid = rev_3.id)
  • Buffers: shared hit=1156 read=115
67. 0.333 269.425 ↓ 617.0 617 1

Subquery Scan on *SELECT* 6 (cost=395.55..868.32 rows=1 width=284) (actual time=246.079..269.425 rows=617 loops=1)

  • Buffers: shared hit=121517 read=48
68. 0.452 269.092 ↓ 617.0 617 1

Result (cost=395.55..868.31 rows=1 width=132) (actual time=246.077..269.092 rows=617 loops=1)

  • One-Time Filter: (101 = ANY ('{100,101,102}'::integer[]))
  • Buffers: shared hit=121517 read=48
69. 1.003 268.640 ↓ 617.0 617 1

Nested Loop Left Join (cost=395.55..868.31 rows=1 width=132) (actual time=246.063..268.640 rows=617 loops=1)

  • Buffers: shared hit=121517 read=48
70. 0.742 265.786 ↓ 617.0 617 1

Nested Loop Left Join (cost=394.99..865.73 rows=1 width=148) (actual time=246.056..265.786 rows=617 loops=1)

  • Buffers: shared hit=118428 read=48
71. 0.496 261.342 ↓ 617.0 617 1

Nested Loop Anti Join (cost=394.43..863.16 rows=1 width=88) (actual time=246.037..261.342 rows=617 loops=1)

  • Buffers: shared hit=115326 read=48
72. 1.716 257.969 ↓ 59.9 959 1

Hash Join (cost=394.02..834.77 rows=16 width=104) (actual time=246.019..257.969 rows=959 loops=1)

  • Hash Cond: (oefvr.objectid = rev_4.timeentryid)
  • Join Filter: ((rev_4.fromtimestamputc <= oefvr.fromtimestamputc) AND ((rev_4.totimestamputc IS NULL) OR (rev_4.totimestamputc > oefvr.fromtimestamputc)))
  • Rows Removed by Join Filter: 3268
  • Buffers: shared hit=111490 read=48
73. 18.563 18.563 ↓ 1.0 959 1

Index Scan using ixoefvr2fromtimestamputc on objectextensionfieldvaluerevision oefvr (cost=0.42..422.19 rows=946 width=80) (actual time=8.251..18.563 rows=959 loops=1)

  • Index Cond: ((fromtimestamputc >= '2019-03-04 23:00:00'::timestamp without time zone) AND (fromtimestamputc < '2019-03-05 23:00:00'::timestamp without time zone))
  • Buffers: shared hit=45 read=48
74. 47.376 237.690 ↓ 21.0 114,248 1

Hash (cost=325.59..325.59 rows=5,441 width=40) (actual time=237.690..237.690 rows=114,248 loops=1)

  • Buckets: 131072 (originally 8192) Batches: 1 (originally 1) Memory Usage: 9156kB
  • Buffers: shared hit=111445
75. 69.180 190.314 ↓ 21.0 114,248 1

Nested Loop (cost=63.42..325.59 rows=5,441 width=40) (actual time=6.218..190.314 rows=114,248 loops=1)

  • Buffers: shared hit=111445
76. 2.517 20.910 ↓ 58.6 3,456 1

Nested Loop (cost=63.00..65.04 rows=59 width=12) (actual time=6.206..20.910 rows=3,456 loops=1)

  • Buffers: shared hit=14020
77. 8.025 8.025 ↓ 3,456.0 3,456 1

HashAggregate (cost=62.72..62.73 rows=1 width=16) (actual time=6.194..8.025 rows=3,456 loops=1)

  • Group Key: timesheetpolicysettingssnapshot_3.timesheetid
  • Buffers: shared hit=3522
  • -> Index Scan using ixtspss2key on timesheetpolicysettingssnapshot timesheetpolicysettingssnapshot_3 (cost=0.55..62.57 rows=59 width=16) (actual time=0.051..4.263 rows=3456 loops=1 (...)
  • Index Cond: ((upper(key) = 'URN:REPLICON:POLICY:TIMESHEET:TIMESHEET-FORMAT'::text) AND (upper(uri) = 'URN:REPLICON:POLICY:TIMESHEET:TIMESHEET-FORMAT:GEN4-TIMESHEET'::text))
  • Buffers: shared hit=3522
78. 10.368 10.368 ↑ 1.0 1 3,456

Index Scan using timesheet_pkey on timesheet ts_5 (cost=0.28..2.30 rows=1 width=28) (actual time=0.002..0.003 rows=1 loops=3,456)

  • Index Cond: (id = timesheetpolicysettingssnapshot_3.timesheetid)
  • Buffers: shared hit=10498
79. 100.224 100.224 ↑ 2.7 33 3,456

Index Scan using ixter2userid on timeentryrevision rev_4 (cost=0.42..3.53 rows=89 width=40) (actual time=0.004..0.029 rows=33 loops=3,456)

  • Index Cond: ((userid = ts_5.userid) AND (entrydate >= ts_5.startdate) AND (entrydate <= ts_5.enddate))
  • Buffers: shared hit=97425
80. 2.877 2.877 ↓ 0.0 0 959

Index Scan using timeentryrevision_singleinitialrevision on timeentryrevision timeentryrevision_1 (cost=0.42..1.76 rows=1 width=24) (actual time=0.003..0.003 rows=0 loops=959)

  • Index Cond: (timeentryid = oefvr.objectid)
  • Filter: (fromtimestamputc = oefvr.fromtimestamputc)
  • Rows Removed by Filter: 1
  • Buffers: shared hit=3836
81. 3.702 3.702 ↑ 1.0 1 617

Index Scan using uix4rakv_uniquekeyuri on revisionauditkeyvalue effectiveuser_3 (cost=0.56..2.56 rows=1 width=76) (actual time=0.006..0.006 rows=1 loops=617)

  • Index Cond: ((revisionauditid = oefvr.openingauditid) AND (upper(keyuri) = 'URN:REPLICON:REVISION-AUDIT-KEY:EFFECTIVE-USER'::text))
  • Buffers: shared hit=3102
82. 1.851 1.851 ↑ 1.0 1 617

Index Scan using uix4rakv_uniquekeyuri on revisionauditkeyvalue actualuser_3 (cost=0.56..2.56 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=617)

  • Index Cond: ((revisionauditid = oefvr.openingauditid) AND (upper(keyuri) = 'URN:REPLICON:REVISION-AUDIT-KEY:ACTUAL-USER'::text))
  • Buffers: shared hit=3089
83. 0.010 264.842 ↓ 1.7 10 1

Subquery Scan on *SELECT* 7 (cost=396.38..2,915.59 rows=6 width=284) (actual time=259.829..264.842 rows=10 loops=1)

  • Buffers: shared hit=113645 read=554
84. 0.029 264.832 ↓ 1.7 10 1

Result (cost=396.38..2,915.53 rows=6 width=108) (actual time=259.828..264.832 rows=10 loops=1)

  • One-Time Filter: (101 = ANY ('{100,101,102}'::integer[]))
  • Buffers: shared hit=113645 read=554
85. 0.023 264.803 ↓ 1.7 10 1

Nested Loop Anti Join (cost=396.38..2,915.53 rows=6 width=108) (actual time=259.812..264.803 rows=10 loops=1)

  • Buffers: shared hit=113645 read=554
86. 0.016 261.350 ↓ 1.7 10 1

Nested Loop Left Join (cost=395.54..2,894.31 rows=6 width=124) (actual time=259.289..261.350 rows=10 loops=1)

  • Buffers: shared hit=113525 read=547
87. 0.015 261.294 ↓ 1.7 10 1

Nested Loop Left Join (cost=394.99..2,878.86 rows=6 width=140) (actual time=259.282..261.294 rows=10 loops=1)

  • Buffers: shared hit=113475 read=547
88. 0.564 261.169 ↓ 1.7 10 1

Nested Loop Anti Join (cost=394.43..2,863.40 rows=6 width=80) (actual time=259.263..261.169 rows=10 loops=1)

  • Buffers: shared hit=113425 read=547
89. 1.473 259.699 ↓ 34.8 453 1

Hash Join (cost=394.02..2,826.85 rows=13 width=112) (actual time=217.869..259.699 rows=453 loops=1)

  • Hash Cond: (oefvr_1.objectid = rev_5.timeentryid)
  • Join Filter: ((rev_5.fromtimestamputc <= oefvr_1.totimestamputc) AND ((rev_5.totimestamputc IS NULL) OR (rev_5.totimestamputc > oefvr_1.totimestamputc)))
  • Rows Removed by Join Filter: 3446
  • Buffers: shared hit=111591 read=547
90. 41.346 41.346 ↓ 1.3 969 1

Index Scan using ixoefvr2fromtimestamputc on objectextensionfieldvaluerevision oefvr_1 (cost=0.42..2,418.40 rows=740 width=88) (actual time=0.951..41.346 rows=969 loops=1)

  • Index Cond: ((totimestamputc IS NOT NULL) AND (totimestamputc >= '2019-03-04 23:00:00'::timestamp without time zone) AND (totimestamputc < '2019-03-05 23:00:00'::timestamp without time zone))
  • Buffers: shared hit=146 read=547
91. 44.402 216.880 ↓ 21.0 114,248 1

Hash (cost=325.59..325.59 rows=5,441 width=40) (actual time=216.880..216.880 rows=114,248 loops=1)

  • Buckets: 131072 (originally 8192) Batches: 1 (originally 1) Memory Usage: 9156kB
  • Buffers: shared hit=111445
92. 63.572 172.478 ↓ 21.0 114,248 1

Nested Loop (cost=63.42..325.59 rows=5,441 width=40) (actual time=6.049..172.478 rows=114,248 loops=1)

  • Buffers: shared hit=111445
93. 4.412 19.050 ↓ 58.6 3,456 1

Nested Loop (cost=63.00..65.04 rows=59 width=12) (actual time=6.037..19.050 rows=3,456 loops=1)

  • Buffers: shared hit=14020
94. 7.726 7.726 ↓ 3,456.0 3,456 1

HashAggregate (cost=62.72..62.73 rows=1 width=16) (actual time=6.026..7.726 rows=3,456 loops=1)

  • Group Key: timesheetpolicysettingssnapshot_4.timesheetid
  • Buffers: shared hit=3522
  • -> Index Scan using ixtspss2key on timesheetpolicysettingssnapshot timesheetpolicysettingssnapshot_4 (cost=0.55..62.57 rows=59 width=16) (actual time=0.029..4.168 rows=3456 l (...)
  • Index Cond: ((upper(key) = 'URN:REPLICON:POLICY:TIMESHEET:TIMESHEET-FORMAT'::text) AND (upper(uri) = 'URN:REPLICON:POLICY:TIMESHEET:TIMESHEET-FORMAT:GEN4-TIMESHEET'::text (...)
  • Buffers: shared hit=3522
95. 6.912 6.912 ↑ 1.0 1 3,456

Index Scan using timesheet_pkey on timesheet ts_6 (cost=0.28..2.30 rows=1 width=28) (actual time=0.002..0.002 rows=1 loops=3,456)

  • Index Cond: (id = timesheetpolicysettingssnapshot_4.timesheetid)
  • Buffers: shared hit=10498
96. 89.856 89.856 ↑ 2.7 33 3,456

Index Scan using ixter2userid on timeentryrevision rev_5 (cost=0.42..3.53 rows=89 width=40) (actual time=0.004..0.026 rows=33 loops=3,456)

  • Index Cond: ((userid = ts_6.userid) AND (entrydate >= ts_6.startdate) AND (entrydate <= ts_6.enddate))
  • Buffers: shared hit=97425
97. 0.906 0.906 ↑ 1.0 1 453

Index Scan using ixoefvr2fromtimestamputc on objectextensionfieldvaluerevision (cost=0.42..2.80 rows=1 width=56) (actual time=0.002..0.002 rows=1 loops=453)

  • Index Cond: (fromtimestamputc = oefvr_1.totimestamputc)
  • Filter: ((objectid = oefvr_1.objectid) AND (definitionid = oefvr_1.definitionid) AND (openingauditid = oefvr_1.closingauditid))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=1834
98. 0.110 0.110 ↑ 1.0 1 10

Index Scan using uix4rakv_uniquekeyuri on revisionauditkeyvalue effectiveuser_4 (cost=0.56..2.57 rows=1 width=76) (actual time=0.010..0.011 rows=1 loops=10)

  • Index Cond: ((revisionauditid = oefvr_1.openingauditid) AND (upper(keyuri) = 'URN:REPLICON:REVISION-AUDIT-KEY:EFFECTIVE-USER'::text))
  • Buffers: shared hit=50
99. 0.040 0.040 ↑ 1.0 1 10

Index Scan using uix4rakv_uniquekeyuri on revisionauditkeyvalue actualuser_4 (cost=0.56..2.57 rows=1 width=16) (actual time=0.004..0.004 rows=1 loops=10)

  • Index Cond: ((revisionauditid = oefvr_1.openingauditid) AND (upper(keyuri) = 'URN:REPLICON:REVISION-AUDIT-KEY:ACTUAL-USER'::text))
  • Buffers: shared hit=50
100. 0.030 3.430 ↓ 0.0 0 10

Nested Loop Left Join (cost=0.83..3.14 rows=1 width=24) (actual time=0.343..0.343 rows=0 loops=10)

  • Filter: (child_rev_1.id IS NULL)
  • Rows Removed by Filter: 1
  • Buffers: shared hit=120 read=7
101. 0.100 0.100 ↑ 1.0 1 10

Index Scan using ixtertimeentryid on timeentryrevision rev_6 (cost=0.42..2.66 rows=1 width=40) (actual time=0.008..0.010 rows=1 loops=10)

  • Index Cond: (timeentryid = oefvr_1.objectid)
  • Filter: (totimestamputc = oefvr_1.totimestamputc)
  • Rows Removed by Filter: 5
  • Buffers: shared hit=87
102. 3.300 3.300 ↑ 1.0 1 10

Index Scan using timeentryrevision_uniquepreviousrevisionid on timeentryrevision child_rev_1 (cost=0.42..0.47 rows=1 width=32) (actual time=0.330..0.330 rows=1 loops=10)

  • Index Cond: (previousrevisionid = rev_6.id)
  • Buffers: shared hit=33 read=7
103. 0.307 399.387 ↓ 522.0 522 1

Subquery Scan on *SELECT* 8 (cost=2.78..4,188.10 rows=1 width=284) (actual time=2.592..399.387 rows=522 loops=1)

  • Buffers: shared hit=14050 read=1196
104. 0.591 399.080 ↓ 522.0 522 1

Result (cost=2.78..4,188.09 rows=1 width=108) (actual time=2.592..399.080 rows=522 loops=1)

  • One-Time Filter: (102 = ANY ('{100,101,102}'::integer[]))
  • Buffers: shared hit=14050 read=1196
105. 0.386 398.489 ↓ 522.0 522 1

Nested Loop Left Join (cost=2.78..4,188.09 rows=1 width=108) (actual time=2.579..398.489 rows=522 loops=1)

  • Buffers: shared hit=14050 read=1196
106. 0.730 395.493 ↓ 522.0 522 1

Nested Loop Left Join (cost=2.23..4,185.51 rows=1 width=124) (actual time=2.567..395.493 rows=522 loops=1)

  • Buffers: shared hit=11962 read=1196
107. 1.058 391.109 ↓ 522.0 522 1

Nested Loop Left Join (cost=1.67..4,182.94 rows=1 width=124) (actual time=2.550..391.109 rows=522 loops=1)

  • Buffers: shared hit=9355 read=1193
108. 0.893 124.875 ↓ 522.0 522 1

Nested Loop (cost=1.11..4,180.36 rows=1 width=64) (actual time=2.010..124.875 rows=522 loops=1)

  • Buffers: shared hit=7253 read=677
109. 1.840 116.152 ↓ 522.0 522 1

Nested Loop Left Join (cost=0.83..4,179.88 rows=1 width=64) (actual time=0.635..116.152 rows=522 loops=1)

  • Filter: (child_rev_2.id IS NULL)
  • Rows Removed by Filter: 771
  • Buffers: shared hit=5605 read=664
110. 13.458 13.458 ↓ 1.5 1,293 1

Index Scan using ixter2fromtimestamputc on timeentryrevision rev_7 (cost=0.42..2,370.51 rows=866 width=64) (actual time=0.076..13.458 rows=1,293 loops=1)

  • Index Cond: ((totimestamputc IS NOT NULL) AND (totimestamputc >= '2019-03-04 23:00:00'::timestamp without time zone) AND (totimestamputc < '2019-03-05 23:00:00'::timestamp without time zone))
  • Buffers: shared hit=1140 read=468
111. 100.854 100.854 ↑ 1.0 1 1,293

Index Scan using timeentryrevision_uniquepreviousrevisionid on timeentryrevision child_rev_2 (cost=0.42..2.08 rows=1 width=32) (actual time=0.078..0.078 rows=1 loops=1,293)

  • Index Cond: (previousrevisionid = rev_7.id)
  • Buffers: shared hit=4465 read=196
112. 7.830 7.830 ↑ 2.0 1 522

Index Only Scan using ixtsuseridstartdateenddate on timesheet ts_7 (cost=0.28..0.47 rows=2 width=12) (actual time=0.014..0.015 rows=1 loops=522)

  • Index Cond: ((userid = rev_7.userid) AND (startdate <= rev_7.entrydate) AND (enddate >= rev_7.entrydate))
  • Heap Fetches: 546
  • Buffers: shared hit=1648 read=13
113. 265.176 265.176 ↑ 1.0 1 522

Index Scan using uix4rakv_uniquekeyuri on revisionauditkeyvalue effectiveuser_5 (cost=0.56..2.56 rows=1 width=76) (actual time=0.500..0.508 rows=1 loops=522)

  • Index Cond: ((revisionauditid = rev_7.closingauditid) AND (upper(keyuri) = 'URN:REPLICON:REVISION-AUDIT-KEY:EFFECTIVE-USER'::text))
  • Buffers: shared hit=2102 read=516
114. 3.654 3.654 ↑ 1.0 1 522

Index Scan using uix4rakv_uniquekeyuri on revisionauditkeyvalue actualuser_5 (cost=0.56..2.56 rows=1 width=16) (actual time=0.006..0.007 rows=1 loops=522)

  • Index Cond: ((revisionauditid = rev_7.closingauditid) AND (upper(keyuri) = 'URN:REPLICON:REVISION-AUDIT-KEY:ACTUAL-USER'::text))
  • Buffers: shared hit=2607 read=3
115. 2.610 2.610 ↓ 0.0 0 522

Index Scan using uix4rakv_uniquekeyuri on revisionauditkeyvalue changereason_1 (cost=0.56..2.56 rows=1 width=16) (actual time=0.005..0.005 rows=0 loops=522)

  • Index Cond: ((revisionauditid = rev_7.closingauditid) AND (upper(keyuri) = 'URN:REPLICON:REVISION-AUDIT-KEY:COMMENT'::text))
  • Buffers: shared hit=2088
116. 0.002 0.937 ↓ 0.0 0 1

Subquery Scan on *SELECT* 9 (cost=3,256.20..3,289.36 rows=1 width=357) (actual time=0.937..0.937 rows=0 loops=1)

  • Buffers: shared hit=4 read=2
117. 0.000 0.935 ↓ 0.0 0 1

Nested Loop Left Join (cost=3,256.20..3,289.35 rows=1 width=213) (actual time=0.935..0.935 rows=0 loops=1)

  • Buffers: shared hit=4 read=2
118. 0.001 0.935 ↓ 0.0 0 1

Nested Loop Left Join (cost=3,255.78..3,277.69 rows=1 width=229) (actual time=0.935..0.935 rows=0 loops=1)

  • Buffers: shared hit=4 read=2
119. 0.001 0.934 ↓ 0.0 0 1

Nested Loop (cost=3,255.36..3,266.04 rows=1 width=152) (actual time=0.934..0.934 rows=0 loops=1)

  • Buffers: shared hit=4 read=2
120. 0.001 0.933 ↓ 0.0 0 1

Nested Loop (cost=3,254.94..3,261.59 rows=1 width=99) (actual time=0.933..0.933 rows=0 loops=1)

  • Buffers: shared hit=4 read=2
121. 0.932 0.932 ↓ 0.0 0 1

Index Scan using ixtahaction on timesheetapprovalhistory tah (cost=3,254.66..3,259.28 rows=1 width=79) (actual time=0.932..0.932 rows=0 loops=1)

  • Index Cond: (action = ANY ('{100,101,102}'::integer[]))
  • Filter: ((NOT (hashed SubPlan 3)) AND (timestamputc >= '2019-03-04 23:00:00'::timestamp without time zone) AND (timestamputc < '2019-03-05 23:00:00'::timestamp without time zone) AND (COALESCE(upper(systemp (...)
  • Buffers: shared hit=4 read=2
122.          

SubPlan (forIndex Scan)

123. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=3,229.41..3,254.37 rows=1 width=16) (never executed)

124. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=3,229.12..3,252.04 rows=1 width=24) (never executed)

  • Hash Cond: ((faas.timesheetid = tah_3.timesheetid) AND (faas.nextaction_serialnumber = tah_3.serialnumber))
125.          

CTE firstactionaftersubmit

126. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=2,833.74..2,842.07 rows=833 width=24) (never executed)

  • Group Key: submissions.timesheetid, submissions.serialnumber
127.          

CTE submissions

128. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahaction on timesheetapprovalhistory (cost=0.29..532.45 rows=8,326 width=20) (never executed)

  • Index Cond: (action = 1)
129. 0.000 0.000 ↓ 0.0 0

Merge Join (cost=708.97..2,175.84 rows=16,726 width=24) (never executed)

  • Merge Cond: (submissions.timesheetid = tah_1.timesheetid)
  • Join Filter: (tah_1.serialnumber > submissions.serialnumber)
130. 0.000 0.000 ↓ 0.0 0

Sort (cost=708.68..729.50 rows=8,326 width=20) (never executed)

  • Sort Key: submissions.timesheetid
131. 0.000 0.000 ↓ 0.0 0

CTE Scan on submissions (cost=0.00..166.52 rows=8,326 width=20) (never executed)

132. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.29..597.60 rows=20,075 width=20) (never executed)

133. 0.000 0.000 ↓ 0.0 0

Index Only Scan using ixtah2timesheetid on timesheetapprovalhistory tah_1 (cost=0.29..547.41 rows=20,075 width=20) (never executed)

  • Heap Fetches: 0
134. 0.000 0.000 ↓ 0.0 0

CTE Scan on firstactionaftersubmit faas (cost=0.00..16.66 rows=833 width=24) (never executed)

135. 0.000 0.000 ↓ 0.0 0

Hash (cost=386.92..386.92 rows=9 width=20) (never executed)

136. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahaction on timesheetapprovalhistory tah_3 (cost=0.29..386.92 rows=9 width=20) (never executed)

  • Index Cond: (action = 3)
  • Filter: (upper(systemprocessidentifier) = 'URN:REPLICON:APPROVAL-SYSTEM-PROCESS:TIMESHEET-SUBMIT-SCRIPT-DATA-AND-VALIDATION'::text)
137. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtah2timesheetid on timesheetapprovalhistory tah_2 (cost=0.29..2.31 rows=1 width=36) (never executed)

  • Index Cond: ((timesheetid = faas.timesheetid) AND (serialnumber >= faas.submission_serialnumber) AND (serialnumber <= faas.nextaction_serialnumber))
138. 0.000 0.000 ↓ 0.0 0

Index Scan using timesheet_pkey on timesheet ts_8 (cost=0.28..2.30 rows=1 width=20) (never executed)

  • Index Cond: (id = tah.timesheetid)
139. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtpsstimesheetid on timesheetpolicysettingssnapshot tsformat_1 (cost=0.42..4.44 rows=1 width=101) (never executed)

  • Index Cond: (timesheetid = ts_8.id)
  • Filter: (upper(key) = 'URN:REPLICON:POLICY:TIMESHEET:TIMESHEET-FORMAT'::text)
140. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvtimesheetapprovalhistoryid on timesheetapprovalhistorykeyvalue kv_ea (cost=0.42..11.64 rows=1 width=93) (never executed)

  • Index Cond: (timesheetapprovalhistoryid = tah.id)
  • Filter: (upper(key) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:ACTING-EFFECTIVE-USER'::text)
141. 0.000 0.000 ↓ 0.0 0

Index Scan using ixtahkvtimesheetapprovalhistoryid on timesheetapprovalhistorykeyvalue kv_aa (cost=0.42..11.64 rows=1 width=16) (never executed)

  • Index Cond: (timesheetapprovalhistoryid = tah.id)
  • Filter: (upper(key) = 'URN:REPLICON:APPROVAL-HISTORICAL-ACTION-DATA-KEY:ACTING-ACTUAL-USER'::text)
142. 38.526 38.526 ↑ 1.0 1 6,421

Index Scan using userinfo_pkey on userinfo ui (cost=0.29..1.92 rows=1 width=11) (actual time=0.006..0.006 rows=1 loops=6,421)

  • Index Cond: (id = "*SELECT* 1".userid)
  • Buffers: shared hit=19197 read=66