explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bOnY

Settings
# exclusive inclusive rows x rows loops node
1. 0.025 89,795.899 ↑ 1.0 10 1

Limit (cost=264.59..2,736.54 rows=10 width=272) (actual time=87,229.868..89,795.899 rows=10 loops=1)

2. 0.111 89,795.874 ↑ 531.3 10 1

Nested Loop (cost=264.59..1,313,614.63 rows=5,313 width=272) (actual time=87,229.865..89,795.874 rows=10 loops=1)

  • Join Filter: (dt.agr_id = agreement3_.agr_root_id)
  • Rows Removed by Join Filter: 163
3. 0.050 89,714.183 ↑ 531.3 10 1

Nested Loop Left Join (cost=81.99..1,307,278.33 rows=5,313 width=302) (actual time=87,148.265..89,714.183 rows=10 loops=1)

4. 0.248 89,646.673 ↑ 531.3 10 1

Nested Loop (cost=19.74..976,422.41 rows=5,313 width=238) (actual time=87,081.409..89,646.673 rows=10 loops=1)

5. 0.431 88,263.215 ↑ 59.0 90 1

Nested Loop Left Join (cost=1.14..734,074.77 rows=5,313 width=78) (actual time=82,393.051..88,263.215 rows=90 loops=1)

6. 3.048 88,088.724 ↑ 59.0 90 1

Nested Loop Semi Join (cost=0.86..732,420.64 rows=5,313 width=32) (actual time=82,378.642..88,088.724 rows=90 loops=1)

7. 10.500 83,812.764 ↑ 18.5 4,239 1

Nested Loop Left Join (cost=0.43..382,670.05 rows=78,596 width=32) (actual time=49,544.118..83,812.764 rows=4,239 loops=1)

  • Join Filter: (fmmf.task_type_id = tasktype1_.id)
  • Rows Removed by Join Filter: 2382
  • Filter: ((fmmf.task_type_id IS NULL) OR ((tasktype1_.code)::text <> 'GEOMETRY'::text))
  • Rows Removed by Filter: 2376
8. 83,802.264 83,802.264 ↑ 12.7 6,615 1

Index Scan using fdc_mob_mission_fact_pk on fdc_mob_mission_fact fmmf (cost=0.43..365,979.94 rows=84,285 width=40) (actual time=49,544.055..83,802.264 rows=6,615 loops=1)

  • Filter: ('2020-01-01'::date <= end_date)
  • Rows Removed by Filter: 1198812
9. 0.000 0.000 ↑ 12.0 1 6,615

Materialize (cost=0.00..1.18 rows=12 width=524) (actual time=0.000..0.000 rows=1 loops=6,615)

10. 0.014 0.014 ↑ 4.0 3 1

Seq Scan on fdc_task_type tasktype1_ (cost=0.00..1.12 rows=12 width=524) (actual time=0.010..0.014 rows=3 loops=1)

11. 4,272.912 4,272.912 ↓ 0.0 0 4,239

Index Scan using fdc_mobmisfv_mis_i on fdc_mob_mission_fact_volume mobilemiss2_ (cost=0.43..4.45 rows=1 width=8) (actual time=1.008..1.008 rows=0 loops=4,239)

  • Index Cond: (mission_fact_id = fmmf.id)
  • Filter: ((resume_type)::text = 'NEW'::text)
  • Rows Removed by Filter: 2
12. 174.060 174.060 ↑ 1.0 1 90

Index Scan using fdc_user_md_pk on fdc_user_md fum (cost=0.28..0.31 rows=1 width=62) (actual time=1.934..1.934 rows=1 loops=90)

  • Index Cond: (fmmf.user_id = id)
13. 0.180 1,383.210 ↓ 0.0 0 90

Subquery Scan on dt (cost=18.60..45.60 rows=1 width=160) (actual time=15.369..15.369 rows=0 loops=90)

  • Filter: (dt.customer_id = 1300264)
  • Rows Removed by Filter: 1
14. 0.720 1,383.030 ↑ 1.0 1 90

Limit (cost=18.60..45.59 rows=1 width=232) (actual time=15.360..15.367 rows=1 loops=90)

15. 0.450 1,382.310 ↑ 27.0 1 90

Nested Loop (cost=18.60..747.31 rows=27 width=232) (actual time=15.359..15.359 rows=1 loops=90)

16. 0.270 1,002.420 ↑ 27.0 1 90

Nested Loop (cost=18.18..730.89 rows=27 width=302) (actual time=11.138..11.138 rows=1 loops=90)

17. 0.360 959.220 ↑ 27.0 1 90

Nested Loop (cost=9.88..505.98 rows=27 width=215) (actual time=10.658..10.658 rows=1 loops=90)

18. 0.450 925.740 ↑ 27.0 1 90

Nested Loop (cost=1.57..281.07 rows=27 width=120) (actual time=10.286..10.286 rows=1 loops=90)

19. 0.360 841.140 ↑ 27.0 1 90

Nested Loop (cost=1.29..273.03 rows=27 width=104) (actual time=9.346..9.346 rows=1 loops=90)

20. 0.720 347.040 ↑ 27.0 1 90

Nested Loop (cost=0.86..259.32 rows=27 width=16) (actual time=3.855..3.856 rows=1 loops=90)

21. 221.940 221.940 ↑ 27.0 1 90

Index Scan using fdc_mobmiss_fctlink_i on fdc_mob_mission_fact_link fmmfl (cost=0.43..31.17 rows=27 width=8) (actual time=2.466..2.466 rows=1 loops=90)

  • Index Cond: (mission_fact_id = fmmf.id)
22. 124.380 124.380 ↑ 1.0 1 90

Index Scan using fdc_mob_mission_pk on fdc_mob_mission fmm (cost=0.43..8.45 rows=1 width=24) (actual time=1.382..1.382 rows=1 loops=90)

  • Index Cond: (id = fmmfl.mission_id)
23. 493.740 493.740 ↑ 1.0 1 90

Index Scan using pk_fdc_mob_mission_obj on fdc_mob_mission_obj fmmo (cost=0.42..0.51 rows=1 width=104) (actual time=5.486..5.486 rows=1 loops=90)

  • Index Cond: (id = fmm.mission_obj_id)
24. 84.150 84.150 ↑ 1.0 1 90

Index Scan using fdc_agreement_pk on fdc_agreement agr (cost=0.28..0.30 rows=1 width=24) (actual time=0.935..0.935 rows=1 loops=90)

  • Index Cond: (id = fmm.agreement_root_id)
25. 0.270 33.120 ↑ 1.0 1 90

Limit (cost=8.30..8.31 rows=1 width=103) (actual time=0.368..0.368 rows=1 loops=90)

26. 1.170 32.850 ↑ 1.0 1 90

Sort (cost=8.30..8.31 rows=1 width=103) (actual time=0.364..0.365 rows=1 loops=90)

  • Sort Key: lp.ver_start_date DESC
  • Sort Method: quicksort Memory: 25kB
27. 31.680 31.680 ↑ 1.0 1 90

Index Scan using fdc_legal_person_person_i on fdc_legal_person lp (cost=0.28..8.29 rows=1 width=103) (actual time=0.350..0.352 rows=1 loops=90)

  • Index Cond: (agr.customer_id = root_id)
28. 0.180 42.930 ↑ 1.0 1 90

Limit (cost=8.30..8.31 rows=1 width=103) (actual time=0.477..0.477 rows=1 loops=90)

29. 0.360 42.750 ↑ 1.0 1 90

Sort (cost=8.30..8.31 rows=1 width=103) (actual time=0.475..0.475 rows=1 loops=90)

  • Sort Key: lp2.ver_start_date DESC
  • Sort Method: quicksort Memory: 25kB
30. 42.390 42.390 ↓ 2.0 2 90

Index Scan using fdc_legal_person_person_i on fdc_legal_person lp2 (cost=0.28..8.29 rows=1 width=103) (actual time=0.379..0.471 rows=2 loops=90)

  • Index Cond: (agr.performer_id = root_id)
31. 379.440 379.440 ↑ 1.0 1 90

Index Scan using fdc_object_pk on fdc_object obj (cost=0.42..0.61 rows=1 width=24) (actual time=4.216..4.216 rows=1 loops=90)

  • Index Cond: (id = fmmo.object_id)
32. 6.650 67.460 ↑ 1.0 1 10

Aggregate (cost=62.24..62.25 rows=1 width=64) (actual time=6.745..6.746 rows=1 loops=10)

33. 0.068 60.810 ↑ 2.0 3 10

Nested Loop Left Join (cost=0.85..62.21 rows=6 width=658) (actual time=3.680..6.081 rows=3 loops=10)

34. 0.084 48.470 ↑ 2.0 3 10

Nested Loop (cost=0.72..61.28 rows=6 width=150) (actual time=2.453..4.847 rows=3 loops=10)

35. 0.130 0.130 ↑ 2.0 3 10

Index Scan using fdc_mobmisfv_mis_i on fdc_mob_mission_fact_volume fmmfv (cost=0.43..11.46 rows=6 width=8) (actual time=0.010..0.013 rows=3 loops=10)

  • Index Cond: (mission_fact_id = fmmf.id)
36. 48.256 48.256 ↑ 1.0 1 26

Index Scan using fdc_work_type_pk on fdc_work_type fwt (cost=0.29..8.30 rows=1 width=158) (actual time=1.856..1.856 rows=1 loops=26)

  • Index Cond: (id = fmmfv.work_type_id)
37. 12.272 12.272 ↑ 1.0 1 26

Index Scan using fdc_task_type_pk on fdc_task_type ft (cost=0.14..0.15 rows=1 width=524) (actual time=0.472..0.472 rows=1 loops=26)

  • Index Cond: (fwt.task_type_id = id)
38. 0.032 81.580 ↑ 4.6 17 10

Materialize (cost=182.60..184.55 rows=78 width=8) (actual time=8.155..8.158 rows=17 loops=10)

39. 0.118 81.548 ↑ 4.3 18 1

HashAggregate (cost=182.60..183.38 rows=78 width=8) (actual time=81.539..81.548 rows=18 loops=1)

  • Group Key: agreement3_.agr_root_id
40. 0.103 81.430 ↑ 1.0 78 1

Nested Loop (cost=5.16..182.41 rows=78 width=8) (actual time=38.158..81.430 rows=78 loops=1)

41. 18.067 18.067 ↑ 1.0 1 1

Index Only Scan using fdc_person_pk on fdc_person person4_ (cost=0.28..8.29 rows=1 width=8) (actual time=18.063..18.067 rows=1 loops=1)

  • Index Cond: (id = 1300264)
  • Heap Fetches: 1
42. 52.047 63.260 ↑ 1.0 78 1

Bitmap Heap Scan on fdc_agreement agreement3_ (cost=4.88..173.33 rows=78 width=16) (actual time=20.072..63.260 rows=78 loops=1)

  • Recheck Cond: (customer_id = 1300264)
  • Heap Blocks: exact=63
43. 11.213 11.213 ↑ 1.0 78 1

Bitmap Index Scan on fdc_agreement_orgcust_fk_i (cost=0.00..4.87 rows=78 width=0) (actual time=11.213..11.213 rows=78 loops=1)

  • Index Cond: (customer_id = 1300264)