explain.depesz.com

PostgreSQL's explain analyze made readable

Result: H21n : Optimization for: plan #Fixq

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.953 163.988 ↑ 1.0 10,000 1

Limit (cost=0.43..17,675.63 rows=10,000 width=150) (actual time=0.033..163.988 rows=10,000 loops=1)

2. 12.662 163.035 ↑ 56.4 10,000 1

Nested Loop Left Join (cost=0.43..996,685.48 rows=563,889 width=150) (actual time=0.032..163.035 rows=10,000 loops=1)

3. 80.373 80.373 ↑ 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.016..80.373 rows=10,000 loops=1)

  • Filter: (trip_form_date >= '2019-01-01 00:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 26482
4. 70.000 70.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.006..0.007 rows=1 loops=10,000)

  • Index Cond: (t.request_id = request_id)
Planning time : 0.365 ms
Execution time : 164.769 ms