explain.depesz.com

PostgreSQL's explain analyze made readable

Result: adry

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 19.605 ↓ 0.0 0 1

Nested Loop (cost=1,000.43..6,204.08 rows=4 width=567) (actual time=19.605..19.605 rows=0 loops=1)

2. 0.013 0.013 ↑ 1.0 1 1

Index Scan using "Events_pkey" on "Events" e (cost=0.14..2.36 rows=1 width=524) (actual time=0.012..0.013 rows=1 loops=1)

  • Index Cond: ("Id" = 3)
3. 0.000 19.590 ↓ 0.0 0 1

Nested Loop (cost=1,000.29..6,201.67 rows=4 width=51) (actual time=19.590..19.590 rows=0 loops=1)

4. 0.011 0.011 ↑ 1.0 1 1

Index Scan using "Vendors_pkey" on "Vendors" v (cost=0.29..2.51 rows=1 width=19) (actual time=0.009..0.011 rows=1 loops=1)

  • Index Cond: ("Id" = 21055)
5. 4.348 20.502 ↓ 0.0 0 1

Gather (cost=1,000.00..6,199.13 rows=4 width=48) (actual time=19.578..20.502 rows=0 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
6. 16.154 16.154 ↓ 0.0 0 2

Parallel Seq Scan on "VendorEventTimings" ve (cost=0.00..5,198.73 rows=2 width=48) (actual time=16.154..16.154 rows=0 loops=2)

  • Filter: (("VendorId" = 21055) AND ("EventId" = 3))
  • Rows Removed by Filter: 142214
Planning time : 0.136 ms
Execution time : 20.562 ms