explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iqjO : Optimization for: plan #H3Jr

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 27.400 541.853 ↑ 1.0 1 1

Aggregate (cost=34,313.91..34,313.92 rows=1 width=8) (actual time=541.852..541.853 rows=1 loops=1)

2. 17.255 514.453 ↓ 1.1 103,794 1

Hash Right Join (cost=28,892.17..34,068.04 rows=98,348 width=4) (actual time=437.685..514.453 rows=103,794 loops=1)

  • Hash Cond: (sed.system_error_id = se.id)
3. 60.607 60.607 ↓ 1.1 3,761 1

Index Scan using idx_system_error_details_ps_product_option_id on system_error_details sed (cost=0.43..5,166.96 rows=3,558 width=4) (actual time=0.496..60.607 rows=3,761 loops=1)

  • Index Cond: (ps_product_option_id = ANY ('{5,75,35}'::integer[]))
4. 30.328 436.591 ↓ 1.0 100,174 1

Hash (cost=27,662.39..27,662.39 rows=98,348 width=4) (actual time=436.591..436.591 rows=100,174 loops=1)

  • Buckets: 131,072 Batches: 1 Memory Usage: 4,546kB
5. 406.263 406.263 ↓ 1.0 100,174 1

Seq Scan on system_errors se (cost=0.00..27,662.39 rows=98,348 width=4) (actual time=0.541..406.263 rows=100,174 loops=1)

  • Filter: ((deleted_by IS NULL) AND (cluster_id = ANY ('{1,2}'::integer[])))
  • Rows Removed by Filter: 27,805