explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LQCS

Settings
# exclusive inclusive rows x rows loops node
1. 83.693 1,899.233 ↓ 1,000.0 1,268,047 1

Nested Loop (cost=0.850..2,041,597.640 rows=1,268 width=8) (actual time=0.211..1,899.233 rows=1,268,047 loops=1)

2. 0.146 0.146 ↑ 1.0 7 1

Index Only Scan using tango on mike golf_two (cost=0.290..50.120 rows=7 width=8) (actual time=0.047..0.146 rows=7 loops=1)

  • Index Cond: (quebec = ANY ('juliet_victor_four'::bigint[]))
  • Heap Fetches: 7
3. 1,815.394 1,815.394 ↓ 4.1 181,150 7

Index Scan using lima_xray on whiskey yankee (cost=0.570..291,211.550 rows=43,810 width=16) (actual time=24.210..259.342 rows=181,150 loops=7)

  • Index Cond: ((four >= 'golf_oscar'::timestamp without time zone) AND (juliet_victor_uniform = 'kilo'::bigint) AND (delta = golf_two.quebec))
  • Filter: (echo = ANY ('lima_mike'::integer[]))