explain.depesz.com

PostgreSQL's explain analyze made readable

Result: T5mn

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 12.748 678.767 ↑ 65.8 10 1

Gather Merge (cost=208,351.630..208,428.400 rows=658 width=441) (actual time=669.769..678.767 rows=10 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.063 666.019 ↑ 109.7 3 3 / 3

Sort (cost=207,351.600..207,352.430 rows=329 width=441) (actual time=666.018..666.019 rows=3 loops=3)

  • Sort Key: seven_seven.zulu, seven_seven.seven_papa
  • Sort Method: quicksort Memory: 27kB
  • Worker 0: Sort Method: quicksort Memory: 28kB
  • Worker 1: Sort Method: quicksort Memory: 25kB
3. 6.487 665.956 ↑ 109.7 3 3 / 3

Nested Loop (cost=0.560..207,337.850 rows=329 width=441) (actual time=563.263..665.956 rows=3 loops=3)

4. 532.816 532.816 ↓ 3.7 12,665 3 / 3

Parallel Seq Scan on three_charlie (cost=0.000..180,944.230 rows=3,378 width=66) (actual time=504.223..532.816 rows=12,665 loops=3)

  • Filter: ((("juliet" >= 'six_yankee'::timestamp without time zone) AND ("juliet" <= 'oscar'::timestamp without time zone)) OR ((three_echo >= 'six_yankee'::timestamp without time zone) AND (three_echo <= '2019-11
  • Rows Removed by Filter: 1578727
5. 126.653 126.653 ↓ 0.0 0 37,996 / 3

Index Scan using seven_lima on seven_seven (cost=0.560..7.810 rows=1 width=377) (actual time=0.010..0.010 rows=0 loops=37,996)

  • Index Cond: ((quebec)::text = (three_charlie.six_two)::text)
  • Filter: ((xray)::text = 'tango'::text)
  • Rows Removed by Filter: 1
Planning time : 0.643 ms
Execution time : 678.850 ms