explain.depesz.com

PostgreSQL's explain analyze made readable

Result: e1qM

Settings
# exclusive inclusive rows x rows loops node
1. 0.084 0.546 ↓ 5.0 5 1

Limit (cost=0.42..24.49 rows=1 width=10,536) (actual time=0.129..0.546 rows=5 loops=1)

2. 0.127 0.462 ↓ 5.0 5 1

Nested Loop Left Join (cost=0.42..24.49 rows=1 width=10,536) (actual time=0.113..0.462 rows=5 loops=1)

3. 0.147 0.285 ↓ 5.0 5 1

Nested Loop Left Join (cost=0.27..16.31 rows=1 width=9,976) (actual time=0.071..0.285 rows=5 loops=1)

4. 0.063 0.063 ↓ 5.0 5 1

Index Scan using table1_pkey on table1 a0_ (cost=0.12..8.14 rows=1 width=9,428) (actual time=0.022..0.063 rows=5 loops=1)

  • Filter: (created_at <= '2019-11-25 15:09:33'::timestamp without time zone)
5. 0.075 0.075 ↑ 1.0 1 5

Index Scan using table2_pkey on table2 a1_ (cost=0.14..8.16 rows=1 width=548) (actual time=0.012..0.015 rows=1 loops=5)

  • Index Cond: ((a0_.id)::text = (id)::text)
6. 0.050 0.050 ↓ 0.0 0 5

Index Scan using table3_pkey on table3 a2_ (cost=0.14..8.16 rows=1 width=560) (actual time=0.010..0.010 rows=0 loops=5)

  • Index Cond: ((a0_.id)::text = (id)::text)