explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4LWa : abc

Settings
# exclusive inclusive rows x rows loops node
1. 0.347 7.774 ↑ 1.0 100 1

Sort (cost=717.340..717.590 rows=101 width=488) (actual time=7.761..7.774 rows=100 loops=1)

  • Sort Key: romeo1.two
  • Sort Method: quicksort Memory: 77kB
2. 4.185 7.427 ↑ 1.0 100 1

Hash Join (cost=230.470..713.980 rows=101 width=488) (actual time=0.711..7.427 rows=100 loops=1)

  • Hash Cond: (romeo2.lima_alpha2 = romeo1.lima_alpha2)
3. 2.583 2.583 ↑ 1.0 10,000 1

Seq Scan on oscar foxtrot (cost=0.000..445.000 rows=10,000 width=244) (actual time=0.007..2.583 rows=10,000 loops=1)

4. 0.133 0.659 ↑ 1.0 100 1

Hash (cost=229.200..229.200 rows=101 width=244) (actual time=0.659..0.659 rows=100 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 28kB
5. 0.477 0.526 ↑ 1.0 100 1

Bitmap Heap Scan on lima_november four (cost=5.070..229.200 rows=101 width=244) (actual time=0.080..0.526 rows=100 loops=1)

  • Recheck Cond: (lima_alpha1 < 100)
6. 0.049 0.049 ↑ 1.0 100 1

Bitmap Index Scan on kilo (cost=0.000..5.040 rows=101 width=0) (actual time=0.049..0.049 rows=100 loops=1)

  • Index Cond: (lima_alpha1 < 100)
Planning time : 0.194 ms
Execution time : 8.008 ms