explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vn7I

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 4.759 ↓ 0.0 0 1

Nested Loop (cost=40.43..1,111.00 rows=1,083,334 width=9) (actual time=4.759..4.759 rows=0 loops=1)

2.          

CTE mat_ids

3. 0.311 0.311 ↑ 1.0 1,000 1

Values Scan on ""*VALUES*"" (cost=0.00..17.50 rows=1,000 width=32) (actual time=0.005..0.311 rows=1,000 loops=1)

4. 0.458 1.028 ↓ 5.0 990 1

HashAggregate (cost=22.50..24.50 rows=200 width=32) (actual time=0.885..1.028 rows=990 loops=1)

  • Group Key: (mat_ids.id)::text
5. 0.570 0.570 ↑ 1.0 1,000 1

CTE Scan on mat_ids (cost=0.00..20.00 rows=1,000 width=32) (actual time=0.006..0.570 rows=1,000 loops=1)

6. 3.960 3.960 ↓ 0.0 0 990

Index Only Scan using pk_pdi_smp_chem_2112830689 on pdi_smp_chem (cost=0.43..5.00 rows=34 width=9) (actual time=0.004..0.004 rows=0 loops=990)

  • Index Cond: (material_id = (mat_ids.id)::text)
  • Heap Fetches: 0
Planning time : 1.031 ms
Execution time : 4.844 ms