explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KT2K

Settings
# exclusive inclusive rows x rows loops node
1. 0.034 710.731 ↑ 1.0 1 1

Aggregate (cost=26,382.62..26,382.63 rows=1 width=8) (actual time=710.722..710.731 rows=1 loops=1)

2. 0.034 710.697 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.71..26,382.52 rows=41 width=8) (actual time=710.697..710.697 rows=0 loops=1)

3. 0.043 710.663 ↓ 0.0 0 1

Nested Loop (cost=0.42..26,233.35 rows=41 width=16) (actual time=710.663..710.663 rows=0 loops=1)

4. 710.565 710.565 ↑ 53.0 1 1

Seq Scan on sale sale1_ (cost=0.00..25,785.24 rows=53 width=8) (actual time=628.891..710.565 rows=1 loops=1)

  • Filter: (day = 18,424,552)
  • Rows Removed by Filter: 652,114
5. 0.055 0.055 ↓ 0.0 0 1

Index Scan using print_sale on print print0_ (cost=0.42..8.45 rows=1 width=16) (actual time=0.055..0.055 rows=0 loops=1)

  • Index Cond: (sale = sale1_.id)
  • Filter: (NOT printed)
  • Rows Removed by Filter: 1
6. 0.000 0.000 ↓ 0.0 0

Index Only Scan using tripsale_idx on trip_sale sale1_1_ (cost=0.29..3.63 rows=1 width=8) (never executed)

  • Index Cond: (sale = sale1_.id)
  • Heap Fetches: 0
Execution time : 711.726 ms