explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Fixq

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 1.011 485.447 ↑ 1.0 10,000 1

Limit (cost=0.43..17,647.89 rows=10,000 width=150) (actual time=0.195..485.447 rows=10,000 loops=1)

2. 23.368 484.436 ↑ 56.4 10,000 1

Nested Loop Left Join (cost=0.43..995,121.48 rows=563,889 width=150) (actual time=0.195..484.436 rows=10,000 loops=1)

3. 351.068 351.068 ↑ 56.4 10,000 1

Seq Scan on trip_form t (cost=0.00..329,423.99 rows=563,889 width=82) (actual time=0.063..351.068 rows=10,000 loops=1)

  • Filter: (trip_form_date >= '2019-01-01 00:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 23958
4. 110.000 110.000 ↑ 1.0 1 10,000

Index Scan using idx_request_id on request r (cost=0.43..1.17 rows=1 width=72) (actual time=0.010..0.011 rows=1 loops=10,000)

  • Index Cond: (t.request_id = request_id)
Planning time : 2.508 ms
Execution time : 486.331 ms