explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lVso

Settings
# exclusive inclusive rows x rows loops node
1. 0.028 0.406 ↓ 2.6 67 1

Sort (cost=908.020..908.080 rows=26 width=154) (actual time=0.402..0.406 rows=67 loops=1)

  • Sort Key: two.quebec_seven
  • Sort Method: quicksort Memory: 34kB
2. 0.043 0.378 ↓ 2.6 67 1

HashAggregate (cost=907.140..907.400 rows=26 width=154) (actual time=0.367..0.378 rows=67 loops=1)

  • Group Key: two.five_seven, two.quebec_seven, (0)
3. 0.007 0.335 ↓ 2.6 67 1

Append (cost=0.580..906.950 rows=26 width=154) (actual time=0.025..0.335 rows=67 loops=1)

4. 0.026 0.267 ↓ 2.4 56 1

Nested Loop (cost=0.580..877.770 rows=23 width=73) (actual time=0.024..0.267 rows=56 loops=1)

5. 0.071 0.071 ↑ 1.3 85 1

Index Scan using india on alpha two (cost=0.290..74.520 rows=111 width=73) (actual time=0.013..0.071 rows=85 loops=1)

  • Index Cond: (quebec_sierra < 6)
6. 0.170 0.170 ↑ 1.0 1 85

Index Scan using seven_romeo on delta_xray delta_two_six_two (cost=0.290..7.240 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=85)

  • Index Cond: (quebec_seven = two.three)
  • Filter: (((yankee_echo)::text = 'oscar'::text) AND (seven_papa > (zulu() - 'sierra'::interval)))
  • Rows Removed by Filter: 0
7. 0.017 0.061 ↓ 3.7 11 1

Hash Join (cost=4.130..28.790 rows=3 width=73) (actual time=0.047..0.061 rows=11 loops=1)

  • Hash Cond: (yankee_five.xray = delta_romeo.quebec_seven)
8. 0.025 0.025 ↓ 1.6 11 1

Index Scan using six on delta_two_six_quebec yankee_five (cost=0.280..24.930 rows=7 width=73) (actual time=0.016..0.025 rows=11 loops=1)

  • Index Cond: (quebec_sierra < 6)
  • Filter: ((five_seven five_romeo NOT NULL) AND (seven_papa > (zulu() - 'sierra'::interval)))
  • Rows Removed by Filter: 13
9. 0.006 0.019 ↑ 1.0 21 1

Hash (cost=3.580..3.580 rows=22 width=4) (actual time=0.019..0.019 rows=21 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
10. 0.013 0.013 ↑ 1.0 21 1

Seq Scan on november delta_romeo (cost=0.000..3.580 rows=22 width=4) (actual time=0.005..0.013 rows=21 loops=1)

  • Filter: ((yankee_echo)::text = 'oscar'::text)
  • Rows Removed by Filter: 23
Planning time : 0.696 ms
Execution time : 0.490 ms