explain.depesz.com

PostgreSQL's explain analyze made readable

Result: K3ki : test

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

Sort (cost=56.090..56.110 rows=6 width=41) (actual rows= loops=)

  • Sort Key: delta.seven oscar foxtrot_four
2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=18.310..56.010 rows=6 width=41) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Index Scan using victor on hotel (cost=0.140..2.370 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (foxtrot_sierra = 8)
  • Filter: (sierra <> november ('two'::integer[]))
4. 0.000 0.000 ↓ 0.0

Hash Join (cost=18.170..53.590 rows=6 width=41) (actual rows= loops=)

  • Hash Cond: (delta.seven = echo_xray.seven)
5. 0.000 0.000 ↓ 0.0

Seq Scan on zulu delta (cost=0.000..31.790 rows=1,379 width=33) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Hash (cost=18.120..18.120 rows=4 width=16) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on tango echo_xray (cost=13.880..18.120 rows=4 width=16) (actual rows= loops=)

  • Recheck Cond: (foxtrot_sierra = 8)
8. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on echo_sierra (cost=0.000..13.880 rows=4 width=0) (actual rows= loops=)

  • Index Cond: (foxtrot_sierra = 8)