explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gNBA

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.019 ↓ 0.0 0 1

Nested Loop (cost=0.85..9.09 rows=4 width=567) (actual time=0.019..0.019 rows=0 loops=1)

2. 0.005 0.005 ↑ 1.0 1 1

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

  • Index Cond: ("Id" = 3)
3. 0.001 0.013 ↓ 0.0 0 1

Nested Loop (cost=0.71..6.69 rows=4 width=51) (actual time=0.013..0.013 rows=0 loops=1)

4. 0.006 0.006 ↑ 1.0 1 1

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

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

Index Scan using "VendorIdEventId_idx" on "VendorEventTimings" ve (cost=0.42..4.15 rows=4 width=48) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: (("VendorId" = 21055) AND ("EventId" = 3))
Planning time : 1.532 ms
Execution time : 0.043 ms