explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dGwE

Settings
# exclusive inclusive rows x rows loops node
1. 0.034 5,177.395 ↓ 10.0 10 1

Limit (cost=0.85..86,644.08 rows=1 width=771) (actual time=3.591..5,177.395 rows=10 loops=1)

  • Execution time: 5177.645 ms(35 filas)
2. 0.102 5,177.361 ↓ 10.0 10 1

Nested Loop (cost=0.85..86,644.08 rows=1 width=771) (actual time=3.588..5,177.361 rows=10 loops=1)

3. 0.018 1,048.789 ↓ 10.0 10 1

Append (cost=0.42..892.92 rows=1 width=51) (actual time=1.615..1,048.789 rows=10 loops=1)

4. 1,048.771 1,048.771 ↓ 10.0 10 1

Index Scan using idx_events_page_name on events (cost=0.42..892.92 rows=1 width=51) (actual time=1.613..1,048.771 rows=10 loops=1)

  • Index Cond: ((page_name)::text = 'subscribe'::text)
  • Filter: ((created > '2020-05-19 19:08:13'::timestamp without time zone) AND (operatorid = 1) AND (((restriction)::text ~~* '%usuario%'::text) OR ((restriction)::text ~~ '%token%'::text)))
  • Rows Removed by Filter: 3944
5. 0.362 4,128.470 ↑ 8.0 1 10

Append (cost=0.42..85,751.09 rows=8 width=720) (actual time=0.918..412.847 rows=1 loops=10)

6. 9.150 9.150 ↑ 1.0 1 10

Index Scan using idx_events_trace_id on events e (cost=0.42..8.45 rows=1 width=1,141) (actual time=0.912..0.915 rows=1 loops=10)

  • Index Cond: ((trace_id)::text = (events.trace_id)::text)
  • Filter: ((page_name)::text = 'index.html'::text)
  • Rows Removed by Filter: 2
7. 4,028.211 4,028.211 ↓ 0.0 0 9

Seq Scan on events_20200512 e_1 (cost=0.00..85,691.96 rows=1 width=3,969) (actual time=447.579..447.579 rows=0 loops=9)

  • Filter: (((page_name)::text = 'index.html'::text) AND ((events.trace_id)::text = (trace_id)::text))
  • Rows Removed by Filter: 1522891
8. 16.956 16.956 ↓ 0.0 0 9

Index Scan using idx_events_20200513_trace_id on events_20200513 e_2 (cost=0.43..8.45 rows=1 width=528) (actual time=1.884..1.884 rows=0 loops=9)

  • Index Cond: ((trace_id)::text = (events.trace_id)::text)
  • Filter: ((page_name)::text = 'index.html'::text)
9. 12.951 12.951 ↓ 0.0 0 9

Index Scan using idx_events_20200514_trace_id on events_20200514 e_3 (cost=0.43..8.45 rows=1 width=573) (actual time=1.439..1.439 rows=0 loops=9)

  • Index Cond: ((trace_id)::text = (events.trace_id)::text)
  • Filter: ((page_name)::text = 'index.html'::text)
10. 19.692 19.692 ↓ 0.0 0 9

Index Scan using idx_events_20200515_trace_id on events_20200515 e_4 (cost=0.42..8.45 rows=1 width=571) (actual time=2.188..2.188 rows=0 loops=9)

  • Index Cond: ((trace_id)::text = (events.trace_id)::text)
  • Filter: ((page_name)::text = 'index.html'::text)
11. 16.470 16.470 ↓ 0.0 0 9

Index Scan using idx_events_20200516_trace_id on events_20200516 e_5 (cost=0.42..8.45 rows=1 width=573) (actual time=1.829..1.830 rows=0 loops=9)

  • Index Cond: ((trace_id)::text = (events.trace_id)::text)
  • Filter: ((page_name)::text = 'index.html'::text)
12. 7.065 7.065 ↓ 0.0 0 9

Index Scan using idx_events_20200517_trace_id on events_20200517 e_6 (cost=0.42..8.45 rows=1 width=576) (actual time=0.785..0.785 rows=0 loops=9)

  • Index Cond: ((trace_id)::text = (events.trace_id)::text)
  • Filter: ((page_name)::text = 'index.html'::text)
13. 17.613 17.613 ↓ 0.0 0 9

Index Scan using idx_events_20200518_trace_id on events_20200518 e_7 (cost=0.43..8.45 rows=1 width=1,041) (actual time=1.957..1.957 rows=0 loops=9)

  • Index Cond: ((trace_id)::text = (events.trace_id)::text)
  • Filter: ((page_name)::text = 'index.html'::text)
Planning time : 6.936 ms