explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4Ng1

Settings
# exclusive inclusive rows x rows loops node
1. 46.893 126,879.258 ↓ 11,394.0 11,394 1

Nested Loop Left Join (cost=52,885.87..74,769.11 rows=1 width=382) (actual time=119,646.856..126,879.258 rows=11,394 loops=1)

  • Buffers: shared hit=458097 read=2230212 dirtied=15 written=3
2. 13.031 126,741.213 ↓ 11,394.0 11,394 1

Nested Loop Left Join (cost=52,885.59..74,768.78 rows=1 width=356) (actual time=119,646.610..126,741.213 rows=11,394 loops=1)

  • Buffers: shared hit=441211 read=2229930 dirtied=14 written=3
3. 6.942 125,281.144 ↓ 11,394.0 11,394 1

Nested Loop Left Join (cost=52,885.16..74,768.25 rows=1 width=356) (actual time=119,644.224..125,281.144 rows=11,394 loops=1)

  • Buffers: shared hit=418793 read=2226197 dirtied=10 written=3
4. 10.383 125,228.626 ↓ 11,394.0 11,394 1

Nested Loop Left Join (cost=52,884.88..74,767.94 rows=1 width=353) (actual time=119,644.195..125,228.626 rows=11,394 loops=1)

  • Buffers: shared hit=384632 read=2226167 dirtied=10 written=3
5. 10.282 125,161.273 ↓ 11,394.0 11,394 1

Nested Loop Left Join (cost=52,884.61..74,767.64 rows=1 width=347) (actual time=119,622.980..125,161.273 rows=11,394 loops=1)

  • Buffers: shared hit=367464 read=2226152 dirtied=10 written=3
6. 11.950 125,128.203 ↓ 11,394.0 11,394 1

Nested Loop Left Join (cost=52,884.46..74,767.47 rows=1 width=343) (actual time=119,622.787..125,128.203 rows=11,394 loops=1)

  • Buffers: shared hit=344678 read=2226150 dirtied=10 written=3
7. 10.936 125,093.465 ↓ 11,394.0 11,394 1

Nested Loop Left Join (cost=52,884.19..74,767.17 rows=1 width=310) (actual time=119,622.768..125,093.465 rows=11,394 loops=1)

  • Buffers: shared hit=310497 read=2226149 dirtied=10 written=3
8. 20.269 125,036.953 ↓ 11,394.0 11,394 1

Nested Loop Left Join (cost=52,883.91..74,766.86 rows=1 width=277) (actual time=119,616.811..125,036.953 rows=11,394 loops=1)

  • Buffers: shared hit=276334 read=2226145 dirtied=10 written=3
9. 20.241 125,005.290 ↓ 11,394.0 11,394 1

Nested Loop Left Join (cost=52,883.63..74,766.56 rows=1 width=274) (actual time=119,616.323..125,005.290 rows=11,394 loops=1)

  • Buffers: shared hit=272593 read=2226129 dirtied=10 written=3
10. 456.473 119,891.931 ↓ 11,394.0 11,394 1

Hash Right Join (cost=52,883.21..74,766.02 rows=1 width=250) (actual time=119,614.372..119,891.931 rows=11,394 loops=1)

  • Hash Cond: (cps.ticket_id = pt.id)
  • Buffers: shared hit=235931 read=2217143 dirtied=9 written=3
11. 376.556 376.556 ↑ 1.0 873,431 1

Seq Scan on policy_surrender cps (cost=0.00..18,606.86 rows=873,586 width=75) (actual time=1.203..376.556 rows=873,431 loops=1)

  • Buffers: shared read=9871
12. 29.398 119,058.902 ↓ 11,394.0 11,394 1

Hash (cost=52,883.19..52,883.19 rows=1 width=183) (actual time=119,058.902..119,058.902 rows=11,394 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 2138kB
  • Buffers: shared hit=235928 read=2207272 dirtied=9 written=3
13. 14.085 119,029.504 ↓ 11,394.0 11,394 1

Nested Loop Left Join (cost=2.55..52,883.19 rows=1 width=183) (actual time=87,252.837..119,029.504 rows=11,394 loops=1)

  • Buffers: shared hit=235928 read=2207272 dirtied=9 written=3
14. 19.603 115,107.277 ↓ 11,394.0 11,394 1

Nested Loop Left Join (cost=2.12..52,882.42 rows=1 width=183) (actual time=87,248.745..115,107.277 rows=11,394 loops=1)

  • Buffers: shared hit=198270 read=2199095 dirtied=9 written=3
15. 25.938 115,042.098 ↓ 11,394.0 11,394 1

Nested Loop Left Join (cost=1.84..52,882.12 rows=1 width=176) (actual time=87,248.692..115,042.098 rows=11,394 loops=1)

  • Buffers: shared hit=164088 read=2199095 dirtied=9 written=3
16. 12.446 109,068.492 ↓ 11,394.0 11,394 1

Nested Loop Left Join (cost=1.41..52,875.39 rows=1 width=164) (actual time=87,235.490..109,068.492 rows=11,394 loops=1)

  • Buffers: shared hit=126286 read=2191260 dirtied=9 written=3
17. 21.917 108,873.742 ↓ 11,394.0 11,394 1

Nested Loop (cost=1.13..52,874.51 rows=1 width=135) (actual time=87,232.290..108,873.742 rows=11,394 loops=1)

  • Buffers: shared hit=92434 read=2190926 dirtied=4 written=3
18. 34.709 103,969.437 ↓ 19,222.0 19,222 1

Nested Loop (cost=0.70..52,867.73 rows=1 width=57) (actual time=82,559.520..103,969.437 rows=19,222 loops=1)

  • Join Filter: (pt.status_id = dstat.id)
  • Rows Removed by Join Filter: 192297
  • Buffers: shared hit=26631 read=2179735 dirtied=4 written=3
19. 6.926 6.926 ↓ 11.0 11 1

Seq Scan on dictionary_item dstat (cost=0.00..27.66 rows=1 width=41) (actual time=0.032..6.926 rows=11 loops=1)

  • Filter: (((code)::text ~~ '9%'::text) AND ((code)::text ~~ '9%'::text))
  • Rows Removed by Filter: 900
  • Buffers: shared hit=2 read=12
20. 48.928 103,927.802 ↓ 3,845.8 19,229 11

Nested Loop (cost=0.70..52,840.01 rows=5 width=24) (actual time=2,090.403..9,447.982 rows=19,229 loops=11)

  • Buffers: shared hit=26629 read=2179723 dirtied=4 written=3
21. 50.897 50.897 ↑ 1.0 1 11

Index Scan using dictionary_item_code_idx on dictionary_item dt (cost=0.28..8.29 rows=1 width=4) (actual time=4.623..4.627 rows=1 loops=11)

  • Index Cond: ((code)::text = 'RESIGNATION'::text)
  • Buffers: shared hit=28 read=5
22. 103,827.977 103,827.977 ↓ 43.3 19,229 11

Index Scan using policy_ticket_operation_id_idx on policy_ticket pt (cost=0.42..52,827.27 rows=444 width=28) (actual time=2,085.770..9,438.907 rows=19,229 loops=11)

  • Index Cond: (operation_id = dt.id)
  • Filter: (((status_date)::date >= '2019-05-01'::date) AND ((status_date)::date <= '2019-05-31'::date))
  • Rows Removed by Filter: 855712
  • Buffers: shared hit=26601 read=2179718 dirtied=4 written=3
23. 4,882.388 4,882.388 ↑ 1.0 1 19,222

Index Scan using policy_header_id_idx on policy_header ph (cost=0.43..6.77 rows=1 width=78) (actual time=0.253..0.254 rows=1 loops=19,222)

  • Index Cond: (id = pt.policy_id)
  • Filter: (company_id = 60)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=65803 read=11191
24. 182.304 182.304 ↑ 1.0 1 11,394

Index Scan using system_user_id_idx on system_user author (cost=0.29..0.87 rows=1 width=37) (actual time=0.015..0.016 rows=1 loops=11,394)

  • Index Cond: (id = pt.registerby_id)
  • Buffers: shared hit=33852 read=334 dirtied=5
25. 5,947.668 5,947.668 ↑ 1.0 1 11,394

Index Scan using idx_rep_pol_header on policy_header bph (cost=0.43..6.72 rows=1 width=20) (actual time=0.522..0.522 rows=1 loops=11,394)

  • Index Cond: (id = pt.policy_id)
  • Buffers: shared hit=37802 read=7835
26. 45.576 45.576 ↑ 1.0 1 11,394

Index Scan using dictionary_item_id_idx on dictionary_item dcompany (cost=0.28..0.30 rows=1 width=15) (actual time=0.004..0.004 rows=1 loops=11,394)

  • Index Cond: ((id = ph.company_id) AND (id = 60))
  • Buffers: shared hit=34182
27. 3,908.142 3,908.142 ↑ 1.0 1 11,394

Index Scan using policy_person_insurance_document_id_idx on policy_person pp (cost=0.43..0.76 rows=1 width=8) (actual time=0.338..0.343 rows=1 loops=11,394)

  • Index Cond: (insurance_document_id = ph.id)
  • Filter: ((type)::text = 'OWNER'::text)
  • Rows Removed by Filter: 1
  • Buffers: shared hit=37658 read=8177
28. 5,093.118 5,093.118 ↑ 1.0 1 11,394

Index Scan using person_uid_idx on person owner (cost=0.43..0.52 rows=1 width=32) (actual time=0.447..0.447 rows=1 loops=11,394)

  • Index Cond: (uid = pp.person_uid)
  • Buffers: shared hit=36662 read=8986 dirtied=1
29. 11.394 11.394 ↓ 0.0 0 11,394

Index Scan using partner_branch_id_idx on partner_branch sur_bra (cost=0.28..0.30 rows=1 width=11) (actual time=0.001..0.001 rows=0 loops=11,394)

  • Index Cond: (cps.branch_id = id)
  • Buffers: shared hit=3741 read=16
30. 45.576 45.576 ↑ 1.0 1 11,394

Index Scan using dictionary_item_id_idx on dictionary_item dreason (cost=0.28..0.29 rows=1 width=41) (actual time=0.003..0.004 rows=1 loops=11,394)

  • Index Cond: (id = cps.reason_id)
  • Buffers: shared hit=34163 read=4
31. 22.788 22.788 ↑ 1.0 1 11,394

Index Scan using dictionary_item_id_idx on dictionary_item dfrequency (cost=0.28..0.29 rows=1 width=41) (actual time=0.002..0.002 rows=1 loops=11,394)

  • Index Cond: (id = ph.frequency_id)
  • Buffers: shared hit=34181 read=1
32. 22.788 22.788 ↑ 1.0 1 11,394

Index Scan using product_header_id_idx on product_header pty (cost=0.14..0.16 rows=1 width=12) (actual time=0.001..0.002 rows=1 loops=11,394)

  • Index Cond: (id = ph.product_id)
  • Buffers: shared hit=22786 read=2
33. 56.970 56.970 ↑ 1.0 1 11,394

Index Scan using aggregated_policy_id_idx on aggregated_policy ag (cost=0.28..0.29 rows=1 width=14) (actual time=0.005..0.005 rows=1 loops=11,394)

  • Index Cond: (id = ph.aggregated_policy_id)
  • Buffers: shared hit=17168 read=15
34. 45.576 45.576 ↑ 1.0 1 11,394

Index Scan using partner_branch_id_idx on partner_branch branch (cost=0.28..0.30 rows=1 width=11) (actual time=0.003..0.004 rows=1 loops=11,394)

  • Index Cond: (id = ph.branch_id)
  • Buffers: shared hit=34161 read=30
35. 1,447.038 1,447.038 ↑ 1.0 1 11,394

Index Scan using offer_cpi_id_idx on offer_cpi offe (cost=0.42..0.52 rows=1 width=8) (actual time=0.127..0.127 rows=1 loops=11,394)

  • Index Cond: (ph.offer_id = id)
  • Buffers: shared hit=22418 read=3733 dirtied=4
36. 91.152 91.152 ↑ 1.0 1 11,394

Index Scan using system_user_id_idx on system_user sof (cost=0.29..0.31 rows=1 width=34) (actual time=0.008..0.008 rows=1 loops=11,394)

  • Index Cond: (id = offe.operator_id)