explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PIfd

Settings
# exclusive inclusive rows x rows loops node
1. 0.340 309.711 ↑ 1.0 1 1

Aggregate (cost=28,438.09..28,438.10 rows=1 width=8) (actual time=309.711..309.711 rows=1 loops=1)

2. 22.454 309.371 ↑ 15.7 1,035 1

Gather (cost=3,776.51..28,397.34 rows=16,299 width=4) (actual time=113.547..309.371 rows=1,035 loops=1)

  • Workers Planned: 3
  • Workers Launched: 3
3. 23.775 286.917 ↑ 20.3 259 4

Hash Left Join (cost=2,776.51..25,767.44 rows=5,258 width=4) (actual time=101.432..286.917 rows=259 loops=4)

  • Hash Cond: (sa9_.clclientid = clientstat11_.id)
  • Filter: ((facilitycl18_.id = 53) OR (facilitycl19_.id = 53))
  • Rows Removed by Filter: 129456
4. 39.822 262.303 ↑ 1.3 129,715 4

Hash Left Join (cost=2,684.99..24,830.60 rows=166,944 width=12) (actual time=66.515..262.303 rows=129,715 loops=4)

  • Hash Cond: (sa9_.blserviceauthorizationid = saa10_.id)
5. 58.452 208.478 ↑ 1.3 129,715 4

Hash Left Join (cost=1,746.68..21,742.99 rows=166,944 width=12) (actual time=52.370..208.478 rows=129,715 loops=4)

  • Hash Cond: (this_.blserviceauthorizedid = sa9_.id)
6. 37.488 122.493 ↑ 1.3 129,715 4

Hash Left Join (cost=399.35..16,603.02 rows=166,944 width=8) (actual time=24.555..122.493 rows=129,715 loops=4)

  • Hash Cond: (this_.premployeeid = caregiver2_.id)
7. 65.622 65.622 ↑ 1.3 129,715 4

Parallel Seq Scan on bltimeschedule this_ (cost=0.00..13,953.82 rows=166,944 width=28) (actual time=5.007..65.622 rows=129,715 loops=4)

  • Filter: (startdate >= '2017-01-10 00:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 57869
8. 0.906 19.383 ↑ 1.0 4,572 4

Hash (cost=342.20..342.20 rows=4,572 width=4) (actual time=19.383..19.383 rows=4,572 loops=4)

  • Buckets: 8192 Batches: 1 Memory Usage: 225kB
9. 1.719 18.477 ↑ 1.0 4,572 4

Merge Left Join (cost=0.56..342.20 rows=4,572 width=4) (actual time=0.125..18.477 rows=4,572 loops=4)

  • Merge Cond: (caregiver2_.id = demo5_.premployeeid)
10. 11.667 11.667 ↑ 1.0 4,572 4

Index Only Scan using pk_premployee45 on premployee caregiver2_ (cost=0.28..165.86 rows=4,572 width=4) (actual time=0.061..11.667 rows=4,572 loops=4)

  • Heap Fetches: 4573
11. 5.091 5.091 ↑ 1.0 4,568 4

Index Only Scan using idx_prempdemo_premployeeid_prbuscostcenterid on prempdemo demo5_ (cost=0.28..107.80 rows=4,568 width=8) (actual time=0.059..5.091 rows=4,568 loops=4)

  • Heap Fetches: 0
12. 8.444 27.533 ↑ 1.0 33,437 4

Hash (cost=733.37..733.37 rows=33,437 width=20) (actual time=27.533..27.533 rows=33,437 loops=4)

  • Buckets: 32768 Batches: 2 Memory Usage: 986kB
13. 19.089 19.089 ↑ 1.0 33,437 4

Seq Scan on blserviceauthorized sa9_ (cost=0.00..733.37 rows=33,437 width=20) (actual time=0.036..19.089 rows=33,437 loops=4)

14. 3.399 14.003 ↑ 1.0 16,491 4

Hash (cost=732.18..732.18 rows=16,491 width=8) (actual time=14.003..14.003 rows=16,491 loops=4)

  • Buckets: 32768 Batches: 1 Memory Usage: 837kB
15. 5.743 10.604 ↑ 1.0 16,491 4

Hash Left Join (cost=91.52..732.18 rows=16,491 width=8) (actual time=1.242..10.604 rows=16,491 loops=4)

  • Hash Cond: (saa10_.clientid = clientauth12_.id)
16. 3.675 3.675 ↑ 1.0 16,491 4

Seq Scan on blserviceauthorization saa10_ (cost=0.00..413.91 rows=16,491 width=8) (actual time=0.037..3.675 rows=16,491 loops=4)

17. 0.295 1.186 ↑ 1.0 1,405 4

Hash (cost=73.96..73.96 rows=1,405 width=8) (actual time=1.186..1.186 rows=1,405 loops=4)

  • Buckets: 2048 Batches: 1 Memory Usage: 66kB
18. 0.327 0.891 ↑ 1.0 1,405 4

Hash Left Join (cost=2.42..73.96 rows=1,405 width=8) (actual time=0.062..0.891 rows=1,405 loops=4)

  • Hash Cond: (clientauth12_.fcfacilityid = facilitycl19_.id)
19. 0.526 0.526 ↑ 1.0 1,405 4

Seq Scan on clclient clientauth12_ (cost=0.00..66.05 rows=1,405 width=8) (actual time=0.013..0.526 rows=1,405 loops=4)

20. 0.015 0.038 ↑ 1.0 63 4

Hash (cost=1.63..1.63 rows=63 width=4) (actual time=0.038..0.038 rows=63 loops=4)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
21. 0.023 0.023 ↑ 1.0 63 4

Seq Scan on fcfacility facilitycl19_ (cost=0.00..1.63 rows=63 width=4) (actual time=0.014..0.023 rows=63 loops=4)

22. 0.264 0.839 ↑ 1.0 1,405 4

Hash (cost=73.96..73.96 rows=1,405 width=8) (actual time=0.839..0.839 rows=1,405 loops=4)

  • Buckets: 2048 Batches: 1 Memory Usage: 66kB
23. 0.279 0.575 ↑ 1.0 1,405 4

Hash Left Join (cost=2.42..73.96 rows=1,405 width=8) (actual time=0.053..0.575 rows=1,405 loops=4)

  • Hash Cond: (clientstat11_.fcfacilityid = facilitycl18_.id)
24. 0.268 0.268 ↑ 1.0 1,405 4

Seq Scan on clclient clientstat11_ (cost=0.00..66.05 rows=1,405 width=8) (actual time=0.008..0.268 rows=1,405 loops=4)

25. 0.015 0.028 ↑ 1.0 63 4

Hash (cost=1.63..1.63 rows=63 width=4) (actual time=0.028..0.028 rows=63 loops=4)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
26. 0.013 0.013 ↑ 1.0 63 4

Seq Scan on fcfacility facilitycl18_ (cost=0.00..1.63 rows=63 width=4) (actual time=0.007..0.013 rows=63 loops=4)