explain.depesz.com

PostgreSQL's explain analyze made readable

Result: peGj

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

Merge Join (cost=7,849,695.430..7,883,631.240 rows=1,948,001 width=63) (actual rows= loops=)

  • Merge Cond: (alpha.tango = (quebec.tango)::text)
2. 0.000 0.000 ↓ 0.0

Sort (cost=274.150..283.000 rows=3,541 width=32) (actual rows= loops=)

  • Sort Key: alpha.tango
3. 0.000 0.000 ↓ 0.0

Seq Scan on six alpha (cost=0.000..65.410 rows=3,541 width=32) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Materialize (cost=7,849,421.280..7,858,817.460 rows=1,879,235 width=68) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Sort (cost=7,849,421.280..7,854,119.370 rows=1,879,235 width=68) (actual rows= loops=)

  • Sort Key: quebec.tango
6. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on foxtrot quebec (cost=892,712.450..7,499,427.890 rows=1,879,235 width=68) (actual rows= loops=)

  • Recheck Cond: ((echo)::text = ANY ('golf'::text[]))
7. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on romeo (cost=0.000..892,242.640 rows=1,879,235 width=0) (actual rows= loops=)

  • Index Cond: ((echo)::text = ANY ('golf'::text[]))