explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cmAD

Settings
# exclusive inclusive rows x rows loops node
1. 0.042 0.694 ↑ 1.0 100 1

Limit (cost=0.56..519.74 rows=100 width=632) (actual time=0.020..0.694 rows=100 loops=1)

  • Buffers: shared hit=501
2. 0.118 0.652 ↑ 338,549.7 100 1

Nested Loop (cost=0.56..175,766,779.43 rows=33,854,970 width=632) (actual time=0.019..0.652 rows=100 loops=1)

  • Buffers: shared hit=501
3. 0.034 0.034 ↑ 338,549.7 100 1

Seq Scan on table2 b (cost=0.00..563,345.70 rows=33,854,970 width=32) (actual time=0.008..0.034 rows=100 loops=1)

  • Buffers: shared hit=1
4. 0.500 0.500 ↑ 1.0 1 100

Index Scan using table1_pkey on table1 a (cost=0.56..5.17 rows=1 width=600) (actual time=0.005..0.005 rows=1 loops=100)

  • Index Cond: (id = b.table1_id)
  • Buffers: shared hit=500