explain.depesz.com

PostgreSQL's explain analyze made readable

Result: H3Jr

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.871 1,374.988 ↑ 1.0 1 1

Aggregate (cost=498,568.48..498,568.51 rows=1 width=8) (actual time=1,374.987..1,374.988 rows=1 loops=1)

2. 4.155 1,374.117 ↓ 1.5 3,784 1

Nested Loop (cost=0.42..498,562.30 rows=2,473 width=4) (actual time=0.620..1,374.117 rows=3,784 loops=1)

3. 1,362.192 1,362.192 ↓ 1.2 3,885 1

Seq Scan on system_error_details sed (cost=0.00..489,114.41 rows=3,226 width=4) (actual time=0.586..1,362.192 rows=3,885 loops=1)

  • Filter: (ps_product_option_id = ANY ('{5,75,35}'::integer[]))
  • Rows Removed by Filter: 2,087,549
4. 7.770 7.770 ↑ 1.0 1 3,885

Index Scan using pk_system_errors on system_errors se (cost=0.42..2.93 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=3,885)

  • Index Cond: (id = sed.system_error_id)
  • Filter: ((deleted_by IS NULL) AND (cluster_id = ANY ('{1,2}'::integer[])))
  • Rows Removed by Filter: 0
Planning time : 1.128 ms
Execution time : 1,375.081 ms