explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ooy7

Settings
# exclusive inclusive rows x rows loops node
1. 50.717 95.472 ↓ 1.1 200,000 1

Hash Join (cost=5,823.27..391,388.22 rows=178,526 width=39) (actual time=22.840..95.472 rows=200,000 loops=1)

  • Hash Cond: (nav.attr_id = na.attr_id)
2. 22.120 44.673 ↓ 1.1 200,000 1

Bitmap Heap Scan on t_nextapp_attr_val nav (cost=5,816.77..390,903.15 rows=178,526 width=35) (actual time=22.730..44.673 rows=200,000 loops=1)

  • Recheck Cond: ((brand_id = 'blk-id'::text) AND (pid > 100000) AND (pid <= 101000))
  • Heap Blocks: exact=1970
3. 22.553 22.553 ↓ 1.1 200,000 1

Bitmap Index Scan on t_nextapp_attr_val_pkey (cost=0.00..5,772.14 rows=178,526 width=0) (actual time=22.553..22.553 rows=200,000 loops=1)

  • Index Cond: ((brand_id = 'blk-id'::text) AND (pid > 100000) AND (pid <= 101000))
4. 0.046 0.082 ↑ 1.0 200 1

Hash (cost=4.00..4.00 rows=200 width=12) (actual time=0.081..0.082 rows=200 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 17kB
5. 0.036 0.036 ↑ 1.0 200 1

Seq Scan on t_nextapp_attr na (cost=0.00..4.00 rows=200 width=12) (actual time=0.006..0.036 rows=200 loops=1)

Planning time : 0.627 ms
Execution time : 101.714 ms