explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uMGO

Settings
# exclusive inclusive rows x rows loops node
1. 4.306 201,239.465 ↑ 1.0 12,000 1

Limit (cost=101.52..1,092,435.81 rows=12,000 width=71) (actual time=8,263.441..201,239.465 rows=12,000 loops=1)

  • Buffers: shared hit=8568279 read=887815 dirtied=953 written=20888
2. 26,429.052 201,235.159 ↑ 8,688.2 12,000 1

Nested Loop (cost=101.52..9,490,459,183.67 rows=104,258,843 width=71) (actual time=8,263.440..201,235.159 rows=12,000 loops=1)

  • Buffers: shared hit=8568279 read=887815 dirtied=953 written=20888
3. 455.735 117,310.147 ↑ 252.5 51,705 1

Nested Loop Left Join (cost=1.00..8,121,912,735.39 rows=13,053,667 width=71) (actual time=1.954..117,310.147 rows=51,705 loops=1)

  • Filter: ((v.violation_classifier_version IS NULL) OR (v.violation_classifier_version <> '0.13.0'::text))
  • Rows Removed by Filter: 793810
  • Buffers: shared hit=8568279 read=887815 dirtied=953 written=20888
4. 1,726.344 31,651.463 ↑ 44.4 214,617 1

Nested Loop (cost=0.43..11,559,201.58 rows=9,529,611 width=71) (actual time=0.666..31,651.463 rows=214,617 loops=1)

  • Buffers: shared hit=7659026 read=132169 dirtied=950 written=3690
5. 19,917.343 19,917.343 ↑ 1.9 2,501,944 1

Sample Scan on product p (cost=0.00..820,279.05 rows=4,830,902 width=55) (actual time=0.348..19,917.343 rows=2,501,944 loops=1)

  • Sampling: system ('10'::real)
  • Filter: ((status <> 'D'::bpchar) AND (product_type = 1))
  • Rows Removed by Filter: 362949
  • Buffers: shared hit=10502 read=49761 dirtied=949 written=733
6. 10,007.776 10,007.776 ↓ 0.0 0 2,501,944

Index Scan using catalog_item_product_id_fk_idx on catalog_item ci (cost=0.43..2.12 rows=1 width=48) (actual time=0.004..0.004 rows=0 loops=2,501,944)

  • Index Cond: (product_id = p.product_id)
  • Buffers: shared hit=7648524 read=82408 dirtied=1 written=2957
7. 85,202.949 85,202.949 ↑ 208.2 4 214,617

Index Scan using violation_history_catalog_item_id_idx on violation_history v (cost=0.57..765.69 rows=833 width=23) (actual time=0.171..0.397 rows=4 loops=214,617)

  • Index Cond: (ci.catalog_item_id = catalog_item_id)
  • Buffers: shared hit=909253 read=755646 dirtied=3 written=17198
8. 57,495.960 57,495.960 ↓ 0.0 0 51,705

Foreign Scan on merchant_addresses ma (cost=100.52..104.74 rows=1 width=16) (actual time=1.112..1.112 rows=0 loops=51,705)

Planning time : 7.929 ms
Execution time : 201,243.499 ms