explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TXgA

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

Sort (cost=30,500.320..30,570.200 rows=27,950 width=2,200) (actual rows= loops=)

  • Sort Key: six_foxtrot.seven DESC
2. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=190.840..1,878.130 rows=27,950 width=2,200) (actual rows= loops=)

  • Hash Cond: (romeo.quebec = hotel.quebec)
3. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=148.600..1,762.280 rows=27,950 width=1,859) (actual rows= loops=)

  • Hash Cond: (romeo.quebec = yankee_india.quebec)
4. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=105.390..1,645.460 rows=27,950 width=1,343) (actual rows= loops=)

  • Hash Cond: (six_foxtrot.five = romeo.quebec)
5. 0.000 0.000 ↓ 0.0

Seq Scan on six_foxtrot (cost=0.000..1,417.470 rows=46,547 width=859) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Hash (cost=95.860..95.860 rows=762 width=484) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Seq Scan on romeo (cost=0.000..95.860 rows=762 width=484) (actual rows= loops=)

  • Filter: (yankee_mike AND ((whiskey)::text = 'six_victor'::text))
8. 0.000 0.000 ↓ 0.0

Hash (cost=27.540..27.540 rows=1,254 width=516) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Seq Scan on yankee_india (cost=0.000..27.540 rows=1,254 width=516) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Hash (cost=26.550..26.550 rows=1,255 width=333) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Seq Scan on hotel (cost=0.000..26.550 rows=1,255 width=333) (actual rows= loops=)