explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gBHQ

Settings
# exclusive inclusive rows x rows loops node
1. 25.234 4,219.922 ↓ 1.8 44 1

Hash Join (cost=211,776.47..554,679.50 rows=25 width=26) (actual time=2,183.488..4,219.922 rows=44 loops=1)

  • Hash Cond: (r.roster_flight_ref = f.autoid)
2. 14.266 2,925.408 ↑ 1.0 133,720 1

Append (cost=0.00..342,397.11 rows=134,845 width=18) (actual time=0.009..2,925.408 rows=133,720 loops=1)

3. 0.055 0.055 ↑ 1.1 237 1

Seq Scan on tb_roster_flight_remark r (cost=0.00..14.71 rows=271 width=196) (actual time=0.009..0.055 rows=237 loops=1)

4. 16.133 2,911.087 ↑ 1.0 133,483 1

Subquery Scan on *SELECT* 2 (cost=130,653.81..342,382.40 rows=134,574 width=18) (actual time=908.490..2,911.087 rows=133,483 loops=1)

5. 937.015 2,894.954 ↑ 1.0 133,483 1

Hash Join (cost=130,653.81..341,036.66 rows=134,574 width=18) (actual time=908.490..2,894.954 rows=133,483 loops=1)

  • Hash Cond: (rf.ghsflight_ref = f_1.autoid)
6. 1,049.857 1,049.857 ↓ 1.0 2,187,697 1

Seq Scan on tb_roster_flight rf (cost=0.00..200,834.54 rows=2,187,354 width=12) (actual time=0.003..1,049.857 rows=2,187,697 loops=1)

7. 68.168 908.082 ↑ 1.0 133,485 1

Hash (cost=128,971.63..128,971.63 rows=134,574 width=18) (actual time=908.082..908.082 rows=133,485 loops=1)

  • Buckets: 262,144 Batches: 1 Memory Usage: 8,739kB
8. 839.914 839.914 ↑ 1.0 133,485 1

Seq Scan on tb_ghsflights f_1 (cost=0.00..128,971.63 rows=134,574 width=18) (actual time=0.045..839.914 rows=133,485 loops=1)

  • Filter: (remark IS NOT NULL)
  • Rows Removed by Filter: 1,882,309
9. 0.324 1,269.280 ↓ 1.5 630 1

Hash (cost=211,771.31..211,771.31 rows=413 width=14) (actual time=1,269.280..1,269.280 rows=630 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 37kB
10. 1,268.956 1,268.956 ↓ 1.5 630 1

Seq Scan on tb_roster_flight f (cost=0.00..211,771.31 rows=413 width=14) (actual time=4.964..1,268.956 rows=630 loops=1)

  • Filter: ((st >= '2020-07-01 00:00:00'::timestamp without time zone) AND (st <= '2020-07-02 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 2,187,067
Planning time : 1.396 ms
Execution time : 4,220.074 ms