explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gbui

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 921.172 ↑ 200.0 1 1

HashAggregate (cost=118,799.42..118,801.42 rows=200 width=10) (actual time=921.171..921.172 rows=1 loops=1)

  • Group Key: pls_core_leakentry.domain
  • Buffers: shared hit=47704 read=24510
2. 0.000 921.163 ↑ 30,327.0 1 1

Append (cost=0.00..118,723.61 rows=30,327 width=10) (actual time=920.918..921.163 rows=1 loops=1)

  • Buffers: shared hit=47704 read=24510
3. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on pls_core_leakentry (cost=0.00..0.00 rows=1 width=32) (actual time=0.009..0.009 rows=0 loops=1)

  • Filter: (domain ~~* '%i-tracing.com'::text)
4. 0.209 921.059 ↑ 30,325.0 1 1

Bitmap Heap Scan on pls_core_leakentry1 (cost=475.02..118,721.34 rows=30,325 width=10) (actual time=920.909..921.059 rows=1 loops=1)

  • Recheck Cond: (domain ~~* '%i-tracing.com'::text)
  • Rows Removed by Index Recheck: 70
  • Heap Blocks: exact=10
  • Buffers: shared hit=47704 read=24509
5. 920.850 920.850 ↑ 427.1 71 1

Bitmap Index Scan on leakentry1_domain_idx (cost=0.00..467.44 rows=30,325 width=0) (actual time=920.850..920.850 rows=71 loops=1)

  • Index Cond: (domain ~~* '%i-tracing.com'::text)
  • Buffers: shared hit=47704 read=24499
6. 0.096 0.096 ↓ 0.0 0 1

Seq Scan on test (cost=0.00..2.26 rows=1 width=11) (actual time=0.096..0.096 rows=0 loops=1)

  • Filter: (domain ~~* '%i-tracing.com'::text)
  • Rows Removed by Filter: 101
  • Buffers: shared read=1