explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JJf6

Settings
# exclusive inclusive rows x rows loops node
1. 0.012 159.954 ↑ 1.0 100 1

Limit (cost=19,309.8..19,842.61 rows=100 width=476) (actual time=158.13..159.954 rows=100 loops=1)

  • Buffers: shared hit=4,561, temp read=497 written=1,311
2. 0.186 159.942 ↑ 419.7 100 1

Nested Loop (cost=19,309.8..242,952.88 rows=41,974 width=476) (actual time=158.129..159.942 rows=100 loops=1)

  • Buffers: shared hit=4,561, temp read=497 written=1,311
3. 0.057 159.456 ↑ 419.7 100 1

Merge Join (cost=19,309.52..230,087.61 rows=41,974 width=173) (actual time=157.901..159.456 rows=100 loops=1)

  • Buffers: shared hit=4,482, temp read=497 written=1,311
4. 0.058 159.347 ↑ 419.7 100 1

Nested Loop (cost=19,309.09..211,154.48 rows=41,974 width=168) (actual time=157.888..159.347 rows=100 loops=1)

  • Buffers: shared hit=4,383, temp read=497 written=1,311
5. 0.051 159.289 ↑ 419.7 100 1

Nested Loop (cost=19,308.82..198,553.34 rows=41,974 width=169) (actual time=157.883..159.289 rows=100 loops=1)

  • Buffers: shared hit=4,362, temp read=497 written=1,311
6. 0.027 159.238 ↑ 419.7 100 1

Nested Loop (cost=19,308.67..191,633.11 rows=41,974 width=166) (actual time=157.88..159.238 rows=100 loops=1)

  • Buffers: shared hit=4,348, temp read=497 written=1,311
7. 0.050 159.111 ↑ 419.7 100 1

Nested Loop (cost=19,308.53..184,716.91 rows=41,974 width=167) (actual time=157.874..159.111 rows=100 loops=1)

  • Buffers: shared hit=4,148, temp read=497 written=1,311
8. 0.063 158.961 ↑ 419.7 100 1

Nested Loop (cost=19,308.53..177,231.83 rows=41,974 width=167) (actual time=157.829..158.961 rows=100 loops=1)

  • Buffers: shared hit=4,143, temp read=497 written=1,311
9. 0.025 158.798 ↑ 419.7 100 1

Nested Loop (cost=19,308.53..169,746.75 rows=41,974 width=163) (actual time=157.777..158.798 rows=100 loops=1)

  • Buffers: shared hit=4,138, temp read=497 written=1,311
10. 0.055 158.473 ↑ 420.8 100 1

Nested Loop (cost=19,308.11..148,794.94 rows=42,075 width=136) (actual time=157.757..158.473 rows=100 loops=1)

  • Buffers: shared hit=3,738, temp read=497 written=1,311
11. 0.087 158.418 ↑ 420.8 100 1

Nested Loop (cost=19,308.11..148,267 rows=42,075 width=140) (actual time=157.736..158.418 rows=100 loops=1)

  • Buffers: shared hit=3,737, temp read=497 written=1,311
12. 0.002 158.231 ↑ 420.8 100 1

Nested Loop (cost=19,307.69..127,223.82 rows=42,077 width=80) (actual time=157.726..158.231 rows=100 loops=1)

  • Buffers: shared hit=3,337, temp read=497 written=1,311
13. 0.032 158.029 ↑ 863.7 100 1

Nested Loop (cost=19,307.26..86,397.41 rows=86,367 width=76) (actual time=157.72..158.029 rows=100 loops=1)

  • Buffers: shared hit=2,937, temp read=497 written=1,311
14. 0.068 157.797 ↑ 885.9 100 1

Merge Join (cost=19,306.84..35,610.55 rows=88,588 width=36) (actual time=157.701..157.797 rows=100 loops=1)

  • Buffers: shared hit=2,537, temp read=497 written=1,311
15. 0.080 0.080 ↑ 2,662.7 100 1

Index Scan using pk_325 on price_list_pos_325 t325 (cost=0.42..14,084.89 rows=266,266 width=16) (actual time=0.053..0.08 rows=100 loops=1)

  • Index Cond: (t325.id_115_325 = 1,395)
  • Filter: (t325.id_324_325 = 117)
  • Buffers: shared hit=36
16. 0.030 157.649 ↑ 246.7 361 1

Materialize (cost=19,306.37..19,751.58 rows=89,042 width=28) (actual time=157.581..157.649 rows=361 loops=1)

  • Buffers: shared hit=2,501, temp read=497 written=1,311
17. 89.833 157.619 ↑ 246.7 361 1

Sort (cost=19,306.37..19,528.98 rows=89,042 width=28) (actual time=157.579..157.619 rows=361 loops=1)

  • Sort Key: t334.id_325_334
  • Sort Method: external merge Disk: 10,440kB
  • Buffers: shared hit=2,501, temp read=497 written=1,311
18. 39.394 67.786 ↓ 3.0 267,221 1

Nested Loop (cost=0..9,854.64 rows=89,042 width=28) (actual time=0.041..67.786 rows=267,221 loops=1)

  • Buffers: shared hit=2,501
19. 0.034 0.034 ↑ 1.0 1 1

Seq Scan on price_list_pos_version_seq_335 t335 (cost=0..2.26 rows=1 width=12) (actual time=0.034..0.034 rows=1 loops=1)

  • Filter: ((t335.id_115_335 = 1,395) AND (t335.id_324_335 = 117) AND (t335.version_335 = 1))
  • Buffers: shared hit=1
20. 28.358 28.358 ↓ 1.0 267,229 1

Seq Scan on price_list_pos_version_334 t334 (cost=0..5,845.4 rows=267,132 width=28) (actual time=0.006..28.358 rows=267,229 loops=1)

  • Filter: (t334.id_115_334 = 1,395)
  • Buffers: shared hit=2,500
21. 0.200 0.200 ↑ 1.0 1 100

Index Scan using pk_179 on assortment_interface_179 t179 (cost=0.42..0.57 rows=1 width=40) (actual time=0.002..0.002 rows=1 loops=100)

  • Index Cond: ((t179.id_179 = t325.id_179_325) AND (t179.id_115_179 = 1,395))
  • Buffers: shared hit=400
22. 0.200 0.200 ↑ 1.0 1 100

Index Scan using ix_182 on producer_assortment_182 t182 (cost=0.42..0.46 rows=1 width=16) (actual time=0.001..0.002 rows=1 loops=100)

  • Index Cond: ((t182.id_179_182 = t179.id_179) AND (t182.id_115_182 = 1,395))
  • Buffers: shared hit=400
23. 0.100 0.100 ↑ 1.0 1 100

Index Scan using pk_188 on producer_assortment_subaru_188 t188 (cost=0.42..0.5 rows=1 width=76) (actual time=0.001..0.001 rows=1 loops=100)

  • Index Cond: ((t188.id_182_188 = t182.id_182) AND (t188.id_115_188 = 1,395))
  • Buffers: shared hit=400
24. 0.000 0.000 ↑ 1.0 1 100

Materialize (cost=0..2.01 rows=1 width=8) (actual time=0..0 rows=1 loops=100)

  • Buffers: shared hit=1
25. 0.017 0.017 ↑ 1.0 1 1

Seq Scan on price_list_324 t324 (cost=0..2 rows=1 width=8) (actual time=0.016..0.017 rows=1 loops=1)

  • Filter: ((t324.id_115_324 = 1,395) AND (t324.id_324 = 117))
  • Buffers: shared hit=1
26. 0.300 0.300 ↑ 1.0 1 100

Index Scan using pk_336 on price_list_pos_version_subaru_336 t336 (cost=0.42..0.5 rows=1 width=35) (actual time=0.003..0.003 rows=1 loops=100)

  • Index Cond: ((t336.id_334_336 = t334.id_334) AND (t336.id_115_336 = 1,395))
  • Buffers: shared hit=400
27. 0.053 0.100 ↑ 1.4 8 100

Materialize (cost=0..16.3 rows=11 width=12) (actual time=0.001..0.001 rows=8 loops=100)

  • Buffers: shared hit=5
28. 0.047 0.047 ↑ 1.4 8 1

Seq Scan on vat_trans_106 t106a (cost=0..16.24 rows=11 width=12) (actual time=0.046..0.047 rows=8 loops=1)

  • Filter: ((t106a.id_115_106_106 = 1,395) AND (t106a.id_000_106 = 1))
  • Buffers: shared hit=5
29. 0.059 0.100 ↑ 1.4 8 100

Materialize (cost=0..16.3 rows=11 width=12) (actual time=0..0.001 rows=8 loops=100)

  • Buffers: shared hit=5
30. 0.041 0.041 ↑ 1.4 8 1

Seq Scan on vat_trans_106 t106b (cost=0..16.24 rows=11 width=12) (actual time=0.041..0.041 rows=8 loops=1)

  • Filter: ((t106b.id_115_106_106 = 1,395) AND (t106b.id_000_106 = 1))
  • Buffers: shared hit=5
31. 0.100 0.100 ↑ 1.0 1 100

Index Scan using pk_376 on discount_group_376 t376 (cost=0.14..0.17 rows=1 width=11) (actual time=0.001..0.001 rows=1 loops=100)

  • Index Cond: ((t376.id_376 = t334.id_376_334) AND (t376.id_115_376 = t334.id_115_334) AND (t376.id_115_376 = 1,395))
  • Buffers: shared hit=200
32. 0.000 0.000 ↓ 0.0 0 100

Index Scan using pk_376 on discount_group_376 t376j (cost=0.14..0.17 rows=1 width=11) (actual time=0..0 rows=0 loops=100)

  • Index Cond: ((t376j.id_376 = t336.id_376_jpn_336) AND (t376j.id_115_376 = t336.id_115_336) AND (t376j.id_115_376 = 1,395))
  • Buffers: shared hit=14
33. 0.000 0.000 ↓ 0.0 0 100

Index Scan using pk_378 on article_group_rate_subaru_378 t378j (cost=0.28..0.3 rows=1 width=11) (actual time=0..0 rows=0 loops=100)

  • Index Cond: ((t378j.id_378 = t336.id_378_336) AND (t378j.id_115_378 = t336.id_115_336) AND (t378j.id_115_378 = 1,395))
  • Buffers: shared hit=21
34. 0.052 0.052 ↑ 2,449.3 109 1

Index Scan using pk_326 on price_list_pos_deliverer_326 t326 (cost=0.42..17,637.52 rows=266,970 width=13) (actual time=0.008..0.052 rows=109 loops=1)

  • Index Cond: (t326.id_115_326 = 1,395)
  • Buffers: shared hit=99
35. 0.089 0.300 ↑ 1.0 17 100

Materialize (cost=0.28..168.18 rows=17 width=42) (actual time=0.002..0.003 rows=17 loops=100)

  • Buffers: shared hit=79
36. 0.012 0.211 ↑ 1.0 17 1

Nested Loop (cost=0.28..168.09 rows=17 width=42) (actual time=0.175..0.211 rows=17 loops=1)

  • Buffers: shared hit=79
37. 0.182 0.182 ↑ 1.0 17 1

Seq Scan on customer_200 t200 (cost=0..58.44 rows=17 width=28) (actual time=0.168..0.182 rows=17 loops=1)

  • Filter: (t200.id_115_200 = 1,395)
  • Buffers: shared hit=28
38. 0.017 0.017 ↑ 1.0 1 17

Index Scan using pk_621 on customer_data_621 t621 (cost=0.28..6.42 rows=1 width=26) (actual time=0.001..0.001 rows=1 loops=17)

  • Index Cond: ((t621.id_621 = t200.id_621_200) AND (t621.id_115_621 = t200.id_115_200) AND (t621.id_115_621 = 1,395))
  • Buffers: shared hit=51
Planning time : 24.883 ms
Execution time : 163.19 ms